Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining 4 Conditions into 1 Formula!
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 |