hide the #DIV/0

[Manos]

Dear all,
there is anywhere that i can hide or disapear the #DIV/0?
thanks in advance
Manos

 

[Frank Kabel]

Hi Manos
you could change your formulas like the following:
instead of
=A1/B1
use
=IF(OR(B1=0,B1=""),"",A1/B1)

 

[Norman Harker]

Hi Manos!

Best approach is to not do the calculation that results in #DIV/0!

(eg)

=IF(B1="","",A1/B1)

You can use ISERROR but I regard that as a last resort as it might
hide errors that you should know about:

=IF(ISERROR(A1/B1),"",A1/B1)



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

The below example shows how to hide the #DIV/0 in cell
A1. If A1 is blank the calculated cell will be blank, if
not the A1*B4)/3600/24) sum will be run.

=IF(A1=0,"",(A1*B4)/3600/24)

 

[JE McGimpsey]

The best way is to prevent the error in the first place, so instead of


=B1/A1

use

=IF(A1=0,"",B1/A1)

You can change "" to an error message, or a default value.

 

[Guest]

Mano
One way is to try something like thi
=if(iserr(a1/b1)," ",a1/b1
need to replace a1/b1 with own calculatio

 

[Aladin Akyurek]

Supposing that you want A1/B1...

=IF(B1,A1/B1,"")

=IF(N(B1),A1/B1,"")

 

[Dana DeLouis]

XL: How to Create a Conditional Format to Hide Errors

http://support.microsoft.com/default.aspx?scid=kb;en-us;182189&Product=xlw

HTH

 

[Manos]

Can you tell me what N(b1) means?
N is for number or for nothing?

 

[Frank Kabel]

Hi Manos
N() is a funtction (see the Excel help). It converts an expression to a
numerical value

 

[Aladin Akyurek]

N(A1) returns the value in A1 if it's as such a number to Excel.
If A1 is a text value, even if it's a text-formatted number, N will return
0.