| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex If/Then
Can someone help on this formula? Basically, trying to get a "Yes", if the
field, E2, equals, "Open" or "Closed" or "Close Out" or, "Completed". Perhaps there is an easier way. =IF(E2="Open","Yes",(IF(E2="Closed","Yes",IF(E2="C lose Out","Yes","", IF(E2="Completed","Yes",""))) Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Complex If/Then
Here's one way:
=IF(ISNA(MATCH(E2,{"Open","Closed","Close out","Completed"}, 0)),"","Yes") Hope this helps. Pete On Aug 3, 3:50*pm, PAL wrote: Can someone help on this formula? *Basically, trying to get a "Yes", if the field, E2, equals, "Open" or "Closed" or "Close Out" or, "Completed". Perhaps there is an easier way. =IF(E2="Open","Yes",(IF(E2="Closed","Yes",IF(E2="C lose Out","Yes","", IF(E2="Completed","Yes",""))) Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Complex If/Then
You were probably trying to say
=IF(E2="Open","Yes",IF(E2="Closed","Yes",IF(E2="Cl ose Out","Yes", IF(E2="Completed","Yes","")))) An alternative is =IF(OR(E2={"Open","Closed","Close Out","Completed"}),"Yes","") -- David Biddulph "PAL" wrote in message ... Can someone help on this formula? Basically, trying to get a "Yes", if the field, E2, equals, "Open" or "Closed" or "Close Out" or, "Completed". Perhaps there is an easier way. =IF(E2="Open","Yes",(IF(E2="Closed","Yes",IF(E2="C lose Out","Yes","", IF(E2="Completed","Yes",""))) Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Look up | Excel Worksheet Functions | |||
| Complex IF | Excel Discussion (Misc queries) | |||
| Bit of a complex SUM | Excel Worksheet Functions | |||
| Complex IF | Excel Worksheet Functions | |||
| Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
Linear Mode
