Can't get 2 IF formulas to work
These formulas both work in separate Columns, however when I try to use them together in one row/column I get "Incorrect Argument". I would like to get rid of the Balanced? Column and just have the Over/Under. So if columns One+Two+Three+Four are Equal to Grand Total, I would like the Over/Under Column to say Balanced.
These each work separately:
=IF([Grand Total]@row > [One]@row + [Two]@row + [Three]@row + [Four]@row, "UNDER", "OVER")
=IF([Grand Total]@row = [One]@row + [Two]@row + [Three]@row + [Four]@row, "BALANCED")
This is what is giving me the Incorrect Argument or Unparseable:
=IF([Grand Total]@row > [One]@row + [Two]@row + [Three]@row + [Four]@row, "UNDER", "OVER"), IF([Grand Total]@row = [One]@row + [Two]@row + [Three]@row + [Four]@row, "BALANCED"))
Best Answer

Hi @AnnaR
Try this:
=IF([Grand Total]@row = SUM(One@row:Four@row), "BALANCED", IF([Grand Total]@row > SUM(One@row:Four@row), "UNDER", "OVER"))
Keep in mind that IF statements are always true or false. In your original formula, you told it to return "UNDER" if the Grand Total was greater than the sum of One, Two, Three, and Four. Since you put ,"OVER" right after that, you were telling it that if the Grand Total was NOT greater than the sum of One, Two, Three, and Four, it should return "OVER". Since you have three different conditions, you should keep chaining them until there are no conditions left. Because you closed out your first IF statement with both a true and false value, it didn't know what to do with your second IF statement.
Answers

Hi @AnnaR
Try this:
=IF([Grand Total]@row = SUM(One@row:Four@row), "BALANCED", IF([Grand Total]@row > SUM(One@row:Four@row), "UNDER", "OVER"))
Keep in mind that IF statements are always true or false. In your original formula, you told it to return "UNDER" if the Grand Total was greater than the sum of One, Two, Three, and Four. Since you put ,"OVER" right after that, you were telling it that if the Grand Total was NOT greater than the sum of One, Two, Three, and Four, it should return "OVER". Since you have three different conditions, you should keep chaining them until there are no conditions left. Because you closed out your first IF statement with both a true and false value, it didn't know what to do with your second IF statement.

Thank you Julie! I knew it had to be something in how I was entering the conditions, but could not see it.
Help Article Resources
Categories
Check out the Formula Handbook template!