IF Formula calculation Error

Options

Hi

I have the following formula, which works up to a certain point. Let me explain.

=IF(ISBLANK([Original Total Cost]@row), "No", IF([Actual Total Cost]@row > [Original Total Cost]@row, "Yes", "No"))

When the Original Total Cost value is >the Actual Total Cost, the answer is "Yes" - perfect, that's what I need.

When the original Total Cost value is blank, the return response is "No" - again working as I require it to. But when I enter a value in the blank cell, whether the value is greater than or less than the return response is "Yes" and I don't know how to correct it.

Some guidance towards a solution would be appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!