IF Statment

**bigjohnuk** · 11-13-2012, 05:17 AM

Can some explain why

=IF(J2="TRUE",2,4) returns a value of 4

and

=IF(J2="TRU",2,4) returns a value of 2

Does excel do something odd with the word TRUE?

**Fotis1991** · 11-13-2012, 05:23 AM

=IF(J2="TRU",2,4) returns a value of 2

Returns 2 if you have word "TRU"

For the words TRUE and FALSE, excel does not need " "

So with TRUE in J2

IF(J2=TRUE,2,4) returns a value of 2.

**bigjohnuk** · 11-13-2012, 07:02 AM

Hi

No this does not work either. Tried that....

So with TRUE in J2

IF(J2=TRUE,2,4) returns a value of 4 not 2.... no idea why?

IF(J2=TRU,2,4) returns a value of 2. If you drop the E then yes you get the value 2.

So I very much suspect they dont let you use the word TRUE as it is part of the logic.....

Try it and let me know..

**Fotis1991** · 11-13-2012, 07:09 AM

What you say is not correct.

**bigjohnuk** · 11-13-2012, 07:21 AM

If-pain-weight.xlsm

Hi See attached.

IF(J2=TRUE,2,4) returns a value of 4 not 2.... no idea why?

John

**Fotis1991** · 11-13-2012, 07:26 AM

Format J2 as general_not text and type TRUE again.

**bigjohnuk** · 11-13-2012, 07:40 AM

Well that is mad.... So setting the field General and Text, even though the word is text.... it works. Which I think goes to show that Excel does treat the word TRUE as a command type of thing.

John