Trying to build a small function as follows:

AND(IF D2 < "#NA", IF (E2 < "#NA", "INACTIVE", ""))

So, If D2 and E2 contains #NA, do nothing; If D2 or E2 contain #NA, do
nothing; If D2 *AND* E2 contain anything other than #NA, then current
cell = "INACTIVE".


--
ggriffis
------------------------------------------------------------------------
ggriffis's Profile: http://www.excelforum.com/member.php...o&userid=35009
View this thread: http://www.excelforum.com/showthread...hreadid=547479