IF Statement Confusion


I am perplexed by an uber simple IF statement that is giving the wrong results for only a few rows. I am using the following formula:

=IF(Amount@row < "5000.00", 1, 2)

where the amount column is in $.

For all but 3 rows, the correct value is displayed.

I have tried with $ operator and without cents but nothing works. I have deleted rows and recreated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!