Hi
I am trying to capture in an excel formula the follwing:

if A1+A2 =100% and A1 > 50%, allocate 10 point
if A1+A2= 100% and A2 > 50% allocate 9
if A1+A2>75%<100% and A1> 50% allocate 8 Points
if A1+ A2>75%<100% and A2> 50% allocate 7 points
if A1+ A2> 50%<75% and A1 > 50% allocate 6 points

(A1 and A2 are cell values expressed in %)

Grateful for any tipp you might be able to give me what type of formula I could use.

Best

JB