Issues with IF, OR & AND together

[Light_Fandango]

Hello,

I'm an Excel novice and am desperately in need of help! I have successfully put together the following formula:

IF(OR(K2>=3,L2>=3,M2>=3,N2>=5,OR(H2<75)),"R",IF(OR(K2>=2,L2>=2,M2>=2,N2>=3,OR(H2<85),OR(D2="P",D2="S",D2="A")),"Y","G"))

I need to go further than this and include the following:

If K2 >= 3,L2>= 3,M2>= 3 or N2>=5 then R
OR K2 >=2, L2 >= 2, M2 >= 2, N2>= 3 AND H2<85 then R
OR H2 =<80 then R

OR If K2>=2, L2>= 2, M2>= 2, N2= 4 then Y
OR K2>=2, L2>=1, M2>= 1, N2>=3 AND H2>85 but <90 then Y
OR D2="P",D2="S",D2="A" then Y

If none then G

This is what I've come up with but I can't get it to work:

IF(OR(K2>=3,L2>=3,M2>=3,N2>=5),OR(AND(K2>=2,L2>=2,M2>=2,N2>=3,H2>2,H2<85,OR(H2<80)),”R”,IF(OR(K2>=2,L2>=2,M2>=2,N2>=4,OR(AND(K2>=2,L2>=1,M2>=1,N2>=3,H2>85,H2<90),OR(D2="P",D2="S",D2="A")),"Y","G"))

Thank you Excel gods in advance!

[Sindhus]

Hi, This formula may help you.

=IF(OR(OR(K2>=3,L2>=3,M2>=3,N2>=5),AND(H2<85,OR(K2>=2,L2>=2,M2>=2,N2>=3)),H2<=80),"R",IF(OR(OR(K2>=2,L2>=2,M2>=2,N2=4),AND(H2>85,H2<90,OR(K2>=2,L2>=1,M2>=1,N2>=3)),OR(D2="P",D2="S",D2="A")),"Y","G"))

[Light_Fandango]

Thank you kindly! It works