Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using IF, AND and OR functions together
Hi,
I need help with using IF, AND, OR functions together. Here is my problem. I have cell C5 and E5 G5 and I5 K5 and M5 In cell C5, G5 and K5, i have data validation of Chair, Vice Chair, Treasurer. In cell E5, I5 and M5, i have Yes or no. In another cell, i need to check whether C5 has "chair" and E5 has "yes" OR G5 has "chair" and I5 has "yes" OR K5 has "chair" and M5 has "yes". If it does it needs to return True. I Do not want True showing if C5 has "chair" and I5 has "yes" in it. they got to be together. Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF, AND and OR functions together
Hi,
Am Wed, 14 Nov 2012 13:05:38 +0000 schrieb ahs004: C5 and E5 G5 and I5 K5 and M5 In cell C5, G5 and K5, i have data validation of Chair, Vice Chair, Treasurer. In cell E5, I5 and M5, i have Yes or no. In another cell, i need to check whether C5 has "chair" and E5 has "yes" OR G5 has "chair" and I5 has "yes" OR K5 has "chair" and M5 has "yes". If it does it needs to return True. try: =OR(C5&E5="ChairYes",G5&I5="ChairYes",K5&M5="Chair Yes") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
|
|||
|
|||
Quote:
=IF(OR(AND(C5="Chair",E5="Yes"),AND(G5="Chair",I5= "Yes"),AND(K5="Chair",M5="Yes")),TRUE,"") Does this do what you mean? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined functions that are array functions | Excel Programming | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |