Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Ignore #DIV/0!
Can I use an IF function to ignore the #DIV/0 output when making a formula
and if so how and if not what could I use? |
#2
|
|||
|
|||
One way:
Assuming your existing formula is =A1/B1 then use =IF(B1=0,"",A1/B1) In article , DLZ217 wrote: Can I use an IF function to ignore the #DIV/0 output when making a formula and if so how and if not what could I use? |
#3
|
|||
|
|||
Something like...
=IF(IsError(A1 / A2), "",A1 / A2) "DLZ217" wrote in message ... Can I use an IF function to ignore the #DIV/0 output when making a formula and if so how and if not what could I use? |
#4
|
|||
|
|||
One way:
Instead of in say, C1: =A1/B1 use in C1: =IF(ISERROR(A1/B1),"",A1/B1) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "DLZ217" wrote in message ... Can I use an IF function to ignore the #DIV/0 output when making a formula and if so how and if not what could I use? |
#5
|
|||
|
|||
"DLZ217" wrote...
Can I use an IF function to ignore the #DIV/0 output when making a formula and if so how and if not what could I use? You could trap #DIV/0! using =IF(COUNT(1/(ERROR.TYPE(expression)=2)),"ignore",expression) but it's generally better to trap the subexpression causing the error, e.g., to trap it in averages, =IF(COUNT(x),AVERAGE(x),"ignore") and to trap it in denominators, =IF(N(denominator)<0,numerator/denominator,"ignore") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
Ignoring #DIV/0! in a formula | Excel Discussion (Misc queries) | |||
How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) | |||
"Average" with error DIV/0 | Excel Discussion (Misc queries) |