Blank value rather than #DIV/0!

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

Guest

Hi,

I have a cell that calculates retail ratio (D13) and I have two other cells
(Product Revenue (d11) and total revenue (b11). I divide the product revenue
into the total revenue in order to obtain the retail ratio. I am creating a
template where the values for product revenue and total revenue are blank
until people fill them in. I want to make it so that if the denominator is
blank then the retail ratio is blank rather than the #DIV/0!. How do I set
the formula so that retail ratio is blank unless someone fills out the value
for b11 then d13 is blank?

Thanks,
 
Try something like this:

D13: =IF(ISBLANK(B11),"",D11/B11)

OR

D13: =IF(ISERROR(D11/B11),"",D11/B11)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Back
Top