Help with TYPE function

Giganews Newsgroups
Subject: Help with TYPE function
Posted by:  DMDave (captivator…
Date: Sun, 07 May 2006

The result of a formula in my WS is #N/A. I would like to replace that
with 0. The formula I tried is:

I have also tried replacing the (#N/A) in the above formula with the
number 7 (The number which Excel says is returned when the TYPE is
I continue to get the #N/A result.
I also tried the ERROR.TYPE function with no luck.

Anyone know what I may be doing wrong?

Thank You,