Invalid IF statement?

[Rick-O-Shay]

If cell 13 contains 150, why does this formula display the value as 1?

=IF(C13>0,1,IF(C13>100,2,0))


It doesn't make sense to me.

[DonkeyOte]

I suspect the 150 is actually stored as Text and Text > Number.

Also you need to order your IFs correctly given an IF will exit upon first True, ie your >100 would never be actioned (given >0 test would hold True first)

[ChemistB]

As DO said, it never gets to the second IF statement, reorder like so

=IF(C13>100,2,IF(C13>0,1,0))
Does that work for you?

[DonkeyOte]

@ChemistB, thanks for adding some clarity... all I can say is:

WOW - the Text comment on my part is a pretty spectacular howler especially when you consider I even answered the problem in the remainder of the post !
Time for me to take a break methinks...