If And

G

ggriffis

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".
 
M

Marcelo

try

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

Hope its help
Regards from Brazil
Marcelo

"ggriffis" escreveu:
 
B

Bernie Deitrick

ggriffis,

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

HTH,
Bernie
MS Excel MVP
 
Top