If And
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 And
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 |
If And
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 |
All times are GMT +1. The time now is 05:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com