If Statement

D

Donna Bushrod

I have a spreadsheet that has the following info:

Column G = Y/N variable (Y=benefits are calculated N=benefits are not
calculated)
Column I = Regular Hours
Column L = benefit total (this column is calculated if Column is Y or N)

How can I use the IF statement in Column L to reflect Column G?

Do I need to change the variables in Column G to Y=1 and N=2?

Thanks for your help in advance.
 
J

JulieD

Hi Donna

=IF(G1="Y", benefits calculated formula, benefits not calculted formula)
or
=IF(G1="","",IF(G1="Y",benefits calculated formula,benefits not calculted
formula))
so that you see nothing in L1 unless there's something in G1

Regards
JulieD
 
D

Donna Bushrod

Hi Julie,
Thanks for replying. So what do I put in as the function arguments?

Logical_test:
Value_if_true:
Value_if_false:
 
J

JulieD

Hi Donna

well

Logical_Test would be G1="Y"
Value_if_True would be the formula that you wanted to use if G1="Y"
Value_if_False would be the fromula that you wanted to use if G1="N"

if you have only one IF in the statement then if G1 was blank then the
formula then the Value_if_False condition will be displayed until a Y was
entered

this can be suppressed using a nested IF.

But one thing at a time ...

let us know how you go

Cheers
JulieD
 
D

Donna Bushrod

Hi JulieD

I was playing around with the info you sent and this is what I came up with
(and it works)

Using this formula in the benefits column
=IF(G:G="Y", I:I*2, IF(G:G="N",0))

Thanks for your help.
 
J

JulieD

Hi Donna

you don't need the nested IF
=IF(G:G="Y",I:I*2,0)

bit concerned about the referencing of the whole column rather than an
actual cell ...

Cheers
JulieD
 
J

JulieD

Hi Donna

not sure that you actually need the the nested IF
=IF(G:G="Y",I:I*2,0)
should work just as well for you

bit concerned about the referencing of the whole column rather than an
actual cell ...

Cheers
JulieD
 
Top