I think we'll need to see the actual equation as the simplified version will
still work with B blank

Regards

Trevor


"mkerstei" wrote in
message ...

I have a set equation that needs to be run on about a thousand different
entries. A simplified version of the equation would be =A+B+C-D. The
only problem is, "B" is only found in some of the entries. So for the
majority of the times the equation is run for the different entries, it
works, but when "B" is nonexistent, the equation returns a #N/A value.
Is there anyway I can keep the set equation but make it work when B
does not exist?


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile:
http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=391362