Forum Discussion
Excel not accepting zero from the formula in my spreadsheet
Hi Everyone, Appreciate if someone can please help me on this. Cell F4 (red) is based on the formula in cell F3 (yellow). It should show up as zero but does not do so. If I get rid of the formula...
Hi,
in your formulas, your a using "0" as result for some IF statements. "0" is seen as a string/text, not a number. Change "0" to 0 and it should work.
Best,
Mourad
- Thanks a lot
