IF statement

[Jo]

Hi
I cannot get the following to return a true value.
=IF(I20="POS","t","f")
Do I need to do this in VBA or can I do this as a
worksheet function?
Thanks
Jo

 

[Frank Kabel]

Hi
do you mean
=IF(I20="POS",True,False)

 

[JE McGimpsey]

Your formula syntax is correct. Does cell I20 contain "POS"?

 

[CLR]

Try this.......

=IF(I20="POS",TRUE,FALSE)

Vaya con Dios,
Chuck, CABGx3

 

[Ron Rosenfeld]

Try this.......

=IF(I20="POS",TRUE,FALSE)

Vaya con Dios,
Chuck, CABGx3

If all you want as a result is TRUE or FALSE, then the IF function may be
superfluous.

You get the same result with the formula:

=I20="POS"

Of course, the result is a Boolean and not a text string.


--ron