Combining If Error formula with my existing formula.
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.
Help Article Resources
Check out the Formula Handbook template!