remove div/0 error values from excel cells

[gar_ka]

Hi guys,

i am stuck with a problem , how to remove div/0 value from excel cells.
i got this when i used formula where denominator is zero . is there any function to do or we should write any macro for that.

 

[Sal Paradise]

Excellent.

Thank you for that splendid info. Now I can stop beating myself over the head about this.

 

[Stormseed]

thanks for the clarification Jon Von !

ok....now that you have clarified the same...I guess you will clarify my other question too !

You know the Error_val (Error Value) for DIV/0 error which is 2 and it will return 0 if the condition is met. How can one determine or predict an error value for other errors? Is it that my question goes wrong here just because this stuff is only supposed to work only for DIV/0 error? If not then how do you predict error values for other errors?

 

[Jon von der Heyden]

If I understand your question properly:

ERROR.TYPE(x)=2 is for DIV/0 only, but there are other reference no.'s for the other error types. Have a look here:
http://office.microsoft.com/en-gb/excel/HP052090791033.aspx

 

[Stormseed]

ERROR.TYPE(x)=2 is for DIV/0 only, but there are other reference no.'s for the other error types. Have a look here:
http://office.microsoft.com/en-gb/excel/HP052090791033.aspx

There you go....!!! THAT WAS IMPRESSIVE !! THANKS PAL