Combining If Error formula with my existing formula.

Cody_Gomez32

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.

Lachlan Stead

Hello Cody,

Should be as simple as this:

=IFERROR((Description5 - Description7) / Description5),0)

Lachlan Stead

Hello Cody,

Should be as simple as this:

=IFERROR((Description5 - Description7) / Description5),0)

Cody_Gomez32

Thank you for your reply. That worked how I needed it to.

Lachlan Stead

Good to hear!