Help with TYPE function

Giganews Newsgroups
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:
=IF(TYPE(C144)=(#N/A),0,(VLOOKUP(NetAdj!C144*7,'Labor
Guideline'!$A$3:$C$75,2)+((NetAdj!C144*7-VLOOKUP(NetAdj!C144*7,'Labor
Guideline'!$A$3:$C$75,1))*0.016))/7)

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
#N/A.
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,
Dave

Replies