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