|Subject:||Help with TYPE function|
|Posted by:||DMDave (captivator…@hotmail.com)|
|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?