replace error by value

Fabbe · Dec 7, 2004

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 · Dec 7, 2004

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

HTH
Jason
Atlanta, GA

Frank Kabel · Dec 7, 2004

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

Francis Hayes (The Excel Addict) · Dec 7, 2004

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 · Dec 7, 2004

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)

replace error by value

Fabbe

Jason Morin

Frank Kabel

Francis Hayes (The Excel Addict)

Guest