| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
avoid div by zero
Dear All,
how can we avoid division by Zero in calculated field using MS QUERY ? thanks in advance sapta |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
avoid div by zero
can't say specifically, but usually, when dealing with formulas you can use
an if statement =if(divisor = 0, 0, dividend/divisor) -- Regards, Tom Ogilvy "sapta" wrote in message ... Dear All, how can we avoid division by Zero in calculated field using MS QUERY ? thanks in advance sapta |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
avoid div by zero
I tried many function before including if,iif,case
but still not found the corrects ones ! thanks -----Original Message----- can't say specifically, but usually, when dealing with formulas you can use an if statement =if(divisor = 0, 0, dividend/divisor) -- Regards, Tom Ogilvy "sapta" wrote in message ... Dear All, how can we avoid division by Zero in calculated field using MS QUERY ? thanks in advance sapta . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Avoid #div/0! | Excel Worksheet Functions | |||
| IF - how to avoid cells with no value | Excel Discussion (Misc queries) | |||
| Trying to avoid nested IFs | Excel Worksheet Functions | |||
| How to avoid #DIV/0 from appearing | Excel Discussion (Misc queries) | |||
| what is this, how do I avoid it? | Excel Discussion (Misc queries) | |||
Linear Mode
