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.

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

hth
Vaya con Dios,
Chuck, CABGx3



"Wonder" wrote:

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.

Give this a try...

=IF(AND(E4=0,F4="C"),Value if True, Value if False)


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=556919

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??

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



"Wonder" wrote:


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??