So funny. I figured it out just and was getting ready to post it and
saw your Post JJ. Mine was different though but the outcome the same.
=IF(D40="n/a","ND",IF(D56="n/a","ND",D40-D56))
I will try yours also though....Nope..Didn't work...Got a #Value!.
Thanks for helping out I really appreciate it! :)
--
Jimmydageek
------------------------------------------------------------------------
Jimmydageek's Profile:
http://www.excelforum.com/member.php...o&userid=31692
View this thread:
http://www.excelforum.com/showthread...hreadid=513933