Simple formula nested in ISERR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

I have a very simple formula: =(D6/C6)*100
Col C is amount sold, Cold D is price
This formula is used to calculate sales on various product
However, on products that have no amounts sold, and no sale price the formula returns #DIV/0
I've found the ISERR and ISERROR functions, but dont know how to intergrate my formula into it, so it shows a "0" instead of the #DIV/0!

Can anybody please help. It would be greatly appreciated

Cheers and thanks

A
 
Try this out.

IF(ISERROR((D6/C6)*1000),"No Numbers",(D6/C6)*1000)

AL said:
Hi All,

I have a very simple formula: =(D6/C6)*1000
Col C is amount sold, Cold D is price.
This formula is used to calculate sales on various products
However, on products that have no amounts sold, and no sale price the formula returns #DIV/0!
I've found the ISERR and ISERROR functions, but dont know how to
Click to expand...
intergrate my formula into it, so it shows a "0" instead of the #DIV/0!.
 
Don't for get to start the function with an = or +
=IF(ISERROR((D6/C6)*1000),"No Numbers",(D6/C6)*1000)

AL said:
Hi All,

I have a very simple formula: =(D6/C6)*1000
Col C is amount sold, Cold D is price.
This formula is used to calculate sales on various products
However, on products that have no amounts sold, and no sale price the formula returns #DIV/0!
I've found the ISERR and ISERROR functions, but dont know how to
Click to expand...
intergrate my formula into it, so it shows a "0" instead of the #DIV/0!.
 
Back
Top