replace error by value

[Fabbe]

Hi,

Can anyone tell me how I can change an error msg (f.e.
#DIV/O!) by any value ?

I have a formula that generates an error msg, but I want
to change it by ZERO.

Thanks,
Fabian

 

[Jason Morin]

=IF(ISERROR(your_formula),0,your_formula)

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
change your formula to something like
=IF(B1=0,0,A1/B1)

 

[Guest]

Modify your formula to check for ERROR

Example:
=IF(ISERROR(A1/$A$20),0,A1/$A$20)

Hope this helps,
Francis Hayes (The Excel Addict)
www.TheExcelAddict.com

 

[Guest]

it would help to know your formula.
somewhere in your formula, it is trying to devide by zero.
example. a1 = 5, b1 = 0. formula - =(a1/b1) = #Div/0
if you want a zero instead of #Div/0 use this

=if(b1=0,0,a1/b1)