That does work for me, but perhaps you really want

=IF(OR(D40="n/a",D56="n/a"),"ND",D40-D56))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jimmydageek"
wrote in message
...

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