Hi all,

I'm trying to generate a score based on two criteria. However the tricky part is that there exists a negative relationship between two criteria.

I've come up with this two piece of formulas... However Excel wouldn't let me combine these two and says this error message "You've entered too many arguments for this function."

The two functions are:

IF(AND(G5="A",H5>=3),"10",IF(AND(G5="A",H5=2),"9",IF(AND(G5="A",H5=1),"8",IF(AND(G5="B",H5>=3),"7",IF(AND(G5="B",H5=2),"6",IF(AND(G5="B",H5=1),"5","False")))))

AND

=IF(AND(G5="C",H5>=3),"2",IF(AND(G5="C",H5=2),"3",IF(AND(G5="C",H5=1),"4",IF(AND(G5="D",H5>=2),"0",IF(AND(G5="D",H5=1),"1","False")))))


Your assistance would be greatly appreciated!!!

I'm including a screenshot for better understanding. Thank you!

problem.png