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