Subtracting with a Formula in Cell

aecross

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!

Paul Newcome

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).

Paul Newcome

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

aecross

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.

Paul Newcome

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).

aecross

That did the trick! Thank you so much!

Paul Newcome

Happy to help. 👍️