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

try

if(and((d2<"#NA"),(E2<"#NA")),"INACTIVE","")

Hope its help
Regards from Brazil
Marcelo

"ggriffis" escreveu:


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

ggriffis,

=IF(OR(ISNA(D2),ISNA(E2)),"","INACTIVE")

HTH,
Bernie
MS Excel MVP


"ggriffis" wrote in message
...

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

=IF(OR(ISNA(D2),ISNA(E2)),"","INACTIVE")

HTH
--
AP

"ggriffis" a écrit
dans le message de news:
...

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