Sum difference between two cells only if one cell is not blank

Hello. I am trying to write a formula that calculates the difference between the "Pitch $" and the "Closed Deal $" only when the "Closed Deal $" cell has a value (aka I don't want inaccurate values reflected in the "Pitched to Closed $ Difference" cell because it's considering a blank cell to be $0). Help?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!