Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Avoid #div/0!
Hi !
I want enter a sumproduct formula involving three ranges. However if any of the range does not have a value the formula returns a #div/0! value. I want to avoid that. Pl help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to avoid nested IFs | Excel Worksheet Functions | |||
Avoid 'Save As' with the same name | Excel Discussion (Misc queries) | |||
How do I avoid getting this: © in spreadsheet when I want this (c | Excel Discussion (Misc queries) | |||
How to avoid name ref in formula? | Excel Discussion (Misc queries) | |||
what is this, how do I avoid it? | Excel Discussion (Misc queries) |