If And

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

[Bernie Deitrick]

ggriffis,

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

HTH,
Bernie
MS Excel MVP


"ggriffis" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Marcelo]

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
>
>

[Ardus Petus]

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

HTH
--
AP

"ggriffis" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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
>