IF AND OR or is it IF OR AND

[robbarba]

Here I am again, coming those more experience than I I have tried multi variations of the this formula

S9 = TASK1 OR TASK2
T9 = Score for TASKS >=.75 IF TASK1 or .85 IF TASK2
U9 = SUM of F9:R9 (F9 G9 H9 I9 to calculate score for TASK1) and (F9 G9 H9 I9 J9 K9 L9 M9 N9 O9 P9 Q9 R9 to calculate score for TASK2)

and this is the closest I could get it to working
=IF(AND(S9="TASK1";U9>=0.75;"PASS";"Fail");OR(S9="TASK2";U9>=0.85;"PASS";"Fail"))

Assistance is appreciated!!

 

[jtakw]

Hi,

Not sure if we should be referencing U9 (as in your formula sample), or T9 as in your description, for the TASK Scores, so adjust the Cell reference accordingly,
Try:

=IF(OR(AND(S9="TASK1",U9>=0.75),AND(S9="TASK2",U9>=0.85)),"PASS","FAIL")

 

[robbarba]

Thank you!! it works like a Charm, forgot to rename TASK1 and TASK2 because I was so excited!!

 

[jtakw]

You're welcome, thanks for the feedback.