| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining 4 Conditions into 1 Formula!
Nice
"Gary''s Student" wrote: Only one variable need to be tested: =IF(O4="yes","Level " & I4 & " Program Completed","Level " & I4 & " Program Not Completed") -- Gary''s Student - gsnu200834 "Danny Boy" wrote: I am trying to establish a formula to produce the following flags in Column Q: Level 1 Program Completed Level 1 Program Not Completed Level 2 Program Completed Level 2 Program Not Completed The following are the conditions I am trying to set up for the formula, but I need some help bringing it all together. I'm good at conceptualizing what I need, but often not so good at my "ands" and my "ors", and my parenthesis. The four conditions below should be expressed with one formula: =IF(I4="1",AND(O4="Yes","Level 1 Program Completed") =If(I4="1", AND(O4="No","Level 1 Program Not Completed") =IF(I4="2",AND(O4="Yes",AND(P4<"","Level 2 Program Completed") =If(I4="2",AND(O4="NO","Level 2 Program Not Completed") Thank you very much for any help! Best, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining IF, ANd and SUM functions in a formula | Excel Worksheet Functions | |||
| Combining Text and formula | Excel Discussion (Misc queries) | |||
| Combining formula | Excel Discussion (Misc queries) | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
| Combining conditions for data entry validation | Excel Worksheet Functions | |||
Threaded Mode
