Formula to return a calculated value, only if the value in another column is not zero



I am looking for help to create a formula to calculate only if the value in another column is NOT ZERO. This is a description of what I am trying to do:

·        If [Projected Estimated Cost] is NOT ZERO, then calculate [Current Cost]@row MINUS [Projected Estimated Cost]@row.

·        If the value of [Projected Estimated Cost] is zero, then [Projected Savings] should appear as zero

·        Return value should appear in the [Projected Savings] row.

Thank you, in advance, for your help.

--Lisa M.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!