Blank value rather than #DIV/0!
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
"ChuckW" wrote:
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,
--
Chuck W
|