Problem solving complex if/and/or formula

[dab37843]

I am having difficulties coming up with a formula to solve the following criteria... please help!!!

1 point for K2=A OR K2=B OR K2=C OR K2=D
1 point for L2>139 OR M2>89 (if both, still only add 1 point)
1 point for N2>149 OR R2<40 OR S2>99 OR T2>199 (if one or more, still only add 1 point)
1 point for O2>125 OR O2 has red font
1 point for W2>26 IF (Q2>1.0 if D2=M OR Q2>0.8 if D2=F)

I need all the points to add up in X2.

[ajm123456789]

post an attachment please

[JosephP]

you will require vba because of the font color criterion. is the color manually applied or applied by conditional formatting?

[dab37843]

attachment posted

[dab37843]

I manually create the color based on criteria but could change it to have a X in one of the cells instead.

[JosephP]

can you clarify the last criterion?
the formula will be something like
=OR(K1={"A","B","C","D"})+OR(L1>139,M1>89)+OR(N1>149,R1<40,S1>99,T1>199)+OR(O1>125,Y1="X")+OR(W1>26)
which assumes Y1=X instead of the red font color and is awaiting details of the W1 criteria

[ajm123456789]

=(IF(OR(K2="A", K2="B", K2="C", K2="D"), 1, 0))+(IF(OR(L2>139, M2>89), 1, 0))+(IF(OR(N2>149, AND(R2<40,R2>0), S2>99, T2>199), 1, 0))+(IF(AND(OR(AND(D2="M", Q2>1), AND(D2="F", Q2>0.8)), W2>26), 1, 0))

Ive got this for all conditions except the second last one with the cell in red.
what do u mean by put an x? would the criteria be:
1 point for O2>125 OR O2 has "an x in it"

[ajm123456789]

ahh ok then use this
=(IF(OR(K2="A", K2="B", K2="C", K2="D"), 1, 0))+(IF(OR(L2>139, M2>89), 1, 0))+(IF(OR(N2>149, AND(R2<40,R2>0), S2>99, T2>199), 1, 0))+(IF(AND(OR(AND(D2="M", Q2>1), AND(D2="F", Q2>0.8)), W2>26), 1, 0))+(IF(OR(O2>125, O2="X"), 1, 0))

[dab37843]

Problem solved! Thank you for all the help!!