How to create an exception formula


I've created a simple formula for showing saving against two price columns that then gives me the final value in a third column.

=[Moreton - First Quotation]@row - [Moreton Final Quotation]@row

The problem is if a zero is entered into a the Moreton Final Quotation column its showing the full value of the first quotation in my final savings column

What i need is it to show any saving so if first quotation is £600 and final quotation is zero then the final saving would be zero also.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!