Subtracting with a Formula in Cell
Hi there 
I am trying to do simple subtraction within my sheet.
=Budget@row  [Estimated OSC]@row  [Expenses]@row
This formula normally functions correctly; however, I recently changed the Budget column to an "IF" formula, and now I am receiving an #INVALID OPERATION error. I am not sure how to structure the subtraction formula to include a cell that has a formula.
Thanks!
Best Answer

Try removing the quotes from around the output numbers. The quotes convert it into a text string. To output a numerical value, you want to have it as just the number (no quotes).
Answers

What is the IF formula in the Budget column? It sounds to me like there may be some text somewhere.

Hi @Paul Newcome  here is the formula: =IF([TIER LEVEL]@row = "TIER I", "500.00", IF([TIER LEVEL]@row = "TIER II", "200.00", "100.00"))
I've tried this with and without the formatting with 2 decimal places.

Try removing the quotes from around the output numbers. The quotes convert it into a text string. To output a numerical value, you want to have it as just the number (no quotes).

That did the trick! Thank you so much!

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!