Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank value rather than #DIV/0!
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average range including blank cells: #DIV/0! | Excel Worksheet Functions | |||
how do you hide the #DIV/0! in a blank spreadsheet? | Excel Discussion (Misc queries) | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
blank instead of DIV/0! | Excel Discussion (Misc queries) |