Forum Discussion
IF function is incorrect
Could use some help regarding a very basic IF function. All I'm doing is "if (A1) is less than (B1), show true or false"
A1 is the sum of 4 cells (C1, C2, C3,C4). C1, C2, and C3 are just numerical inputted values. C4 is an equals formula (add, subtract, multiply, divide) that relates cells only containing numerical inputted values (no formulas).
B1 is just a numerical inputted value.
The IF function I am using is =IF(A1<B1, TRUE, FALSE)
The value for A1 is definitely less than B1, but it is coming back FALSE.
HELP!
1 Reply
Hi Kinsey,
Most probably you have text in A1, any text is always greater than any number. But if you are sure you have number in A1 could you please attach small sample with formula not working properly.
