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.
Help Article Resources
Check out the Formula Handbook template!