Error Cells

[atmosphere]

If I have a formula in cell A3 say "=A1/A2"
and A2 = 0, i obvioulsy get a "# DIV/0!" in A#

im wonderin if there is an excel function that will turn an erro
message into some other text, say a zero, or something of my choice
And if not, is there a way i can make my own excel function that doe
this

thank

 

[Frank Kabel]

Hi
in your case you can change the formula to
=IF(A2=0,"Errortext zero",A1/A2)

Frank

 

[jeff_at_work]

if you get the divide by zero error a solution can be:

IF(COUNT(myRange)<1,"no data",(myRange))
Where the “false” statement is whatever function you are using.

you may not need the count function, just play around with the i
function

 

[RWN]

Yet another;

=IF(ISERROR(A1/A2),0,A1/A2)
(Check out the "Help" for various error detections Search on "ISERR")