Combining If Error formula with my existing formula.

Cody_Gomez32 ✭✭✭
edited 04/17/23 in Formulas and Functions

I currently have a margin formula calculating my profit margin. This formula looks like this =(Description5 - Description7) / Description5

When the sale price and landed cost are zero. I want my margin calculation to show 0% instead of #Divide By Zero.

I know I need to use If Error formula but I ma not sure how this needs to be combined with my current formula.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!