View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny boy Danny boy is offline
external usenet poster
 
Posts: 102
Default 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