IF Formula Help
Hi,
I have a column labeled 'Flag' that uses the formula =IF([Calculated Total]@row < [Total Dollars on Invoice]@row, "FLAG", " ") that either is showing as blank for all rows or if I flip it shows as 'FLAG' for all rows.
The 'calculated total' column is a sum of several other columns and the Total Dollars column is just data that is entered via a form or manually into the field.
I'm not sure what I'm missing.
Thanks,
Answers

Are you sure Total Dollars is an actual number? You can use ISNUMBER to test.
I assume Calculated Total must be a number if it's a result of a SUM formula.
If either of the values are not a number, you will get the result you are getting.

@James Keuning If you are referring to the column types, they are both text/number.
I have noticed that if new data is added to the sheet via the form it is working correctly, it's the old data I imported from Excel that it's not working for.

Try putting VALUE in front of the numbers. Or create a helper column, and use a column formula to put VALUE in front of every value and use this column in the formula.
Help Article Resources
Categories
Check out the Formula Handbook template!