Div Error Formula Gross Margin

[Pacman52]

Hi all, could someone let me know how to stop the #DIV/0 error from showing in the gross margin cell if there are blank references in either one of 2 cells.

For example I have

 =(A1-B1)/A1

to show the gross margin percentage

but if either A1 or B1 doesn't have anything in the cell or is a 0 then how do I use IfError to check both cells or would I be better of using a different method to check for an error?

many thanks Paul.

 

[RoryA]

You could use:

=IFERROR((A1-B1)/A1,0)

for example.

 

[Pacman52]

You could use:

=IFERROR((A1-B1)/A1,0)

for example.

Perfect thanks so much Rory