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
Check out the Formula Handbook template!