If Statements

W

Wonder

I am trying to create an IF statement but I can't get it to work. I
want it to say: IF Cell E4=0 and Cell F4=C, value if true, value if
false.
I don't know how to type the formula to make it work.
 
C

CLR

=IF(AND(E4=0,F4="c"),"TRUE, the conditions exist","FALSE, the conditions do
not exist")

hth
Vaya con Dios,
Chuck, CABGx3
 
W

Wonder

This is what I did:

=IF(AND(E4=0,F4="C"),"Y","N")

But I am getting N if True and Y if false....I want it the other way.
W

What am I doing wrong??
 
C

CLR

Your formula reads thusly:........."if both conditions exist at the same
time, then display Y, otherwise display N"............if you wish the
displays reversed, just reverse the positions of your Y and N.......

=IF(AND(E4=0,F4="C"),"N","Y")

Vaya con Dios,
Chuck, CABGx3
 
Top