Why is it showing the false result?

[jbearnolimits]

=IF(A23=2,I4*A21+(I4*D29),0) A23 is 2, I4 is 7700 A21 is 0.0565 and D29 is 0.007. Why do I get a result of 0?

[MrShorty]

Is A23 exactly equal to 2.00000000000, or is it rounded?

[majosum]

Is the "2" value in cell A23 a number format? Maybe try rewriting the formula with quotation marks (" ") around the 2 in the condition of the IF statement.

[jbearnolimits]

Is A23 exactly equal to 2.00000000000, or is it rounded?

It is exact

[jbearnolimits]

Is the "2" value in cell A23 a number format? Maybe try rewriting the formula with quotation marks (" ") around the 2 in the condition of the IF statement.

That worked....why did that work??!

[majosum]

Someone may be able to elaborate this better than I can, but you need to have things in the same format when you are comparing them. The "2" was probably in Text format. Even when I convert the format to Number, I still have this problem sometimes. I find that adding quotation marks usually fixes the problem.

[jbearnolimits]

Someone may be able to elaborate this better than I can, but you need to have things in the same format when you are comparing them. The "2" was probably in Text format. Even when I convert the format to Number, I still have this problem sometimes. I find that adding quotation marks usually fixes the problem.

Sounds right because it was in text format at first and didn't work. So I changed it to general and it still didn't work. Glad it works now though!

[FDibbins]

test A23 using =isnumber(A23) if you get FALSE back, it is text that just looks like a number.

Where does the answer in A23 come from? Is it from a formula - perhaps with =left/right/mid() somewhere in there? (these all return text for an answer)