Nested IF formula with multiple conditions

Hello, grateful if you could help.

I need to write an IF statement in Excel based on several conditions. If an employee has served for more than 4 years and achieved performance rating "OP'/"AP" in latest 2 years, cell C should return to text "OK", otherwise "N/A".


If C2>=4 & A2="OP" & B2="OP"; D2="OK"

If C2>=4 & A2="OP" & B2="AP"; D2="OK"

If C2>=4 & A2="AP" & B2="OP"; D2="OK"

If C2>=4 & A2="AP" & B2="AP"; D2="OK"

If anything else, output "N/A"

Dear Gatti, Thanks for your help. I tried your method but the output fails to return "OK" even the employee has met all conditions. Please see below picture show that Employee 10 has served for 12 years and got "AP" in latest 2 consecutive years.

Untitled.png

Dear Gatti, Thanks for your help. I tried your method but the output fails to return "OK" even the employee has met all conditions. Please see below picture show that Employee 10 has served for 12 years and got "AP" in latest 2 consecutive years.

Attachment 442949

It would help if you attached an Excel file rather than images so we have data to work with.

Click "Go advanced" then "Paper Clip" icon to add file.

Ford's formula amended

=IF(AND(C2>=4,OR(A2="OP",A2="AP",B2="OP",B2="AP")),"OK","N/A")

value1 value2 value3 value4 Result
C 0 0 0 C
0 A+ 0 0 A+

I have these values C 0 0 0 and the result is C same as second row values are 0 A+ 0 0 and i need the result A+.

anybody can help me please.

@cutebeach: Why are posting on this thread?

Start a new thread and it will help if you can post an Excel file explaining your requirement and showing expected results..

Click "Go advanced" then "Paper Clip" icon to upload file (not image).

thanks dear