My Excel skills are a little rusty and I was trying to assign scores in a table based on the value of 3 variables (Var) in Excel 2010. I put an example below. The idea is the higher score of Var 1 and Var 2 are better. I also want to add a third value which is an alphanumeric and they are different but essentially of equal value. Here is a table and in the last 2 columns I have put in scores that I would assign the value in this table. If the values don't fall into the assigned ranges I would assign an N/A. Any help anyone can give me would be greatly appreciated in coming up with a formula. Thanks! -- Steve
For example here are 3 scenarios and the score I would want to come out.
<CODE>Var 1 = 108, Var 2 = 0.5, Var3 = Red, Score = 3Var 1 = 117, Var 2 = 1.7, Var 3 = Yellow, Score = 8Var 1 = 98, Var 2 = 2.0, Var 3 = Red, Score = N/A Scores ScoresVar 1 >= Var 1 < Var 2 >= Var 2 < Var 3 Red Yellow100 105 1 2 Red or Yellow 1 2105 110 0 1 Red or Yellow 3 4110 115 1 2 Red or Yellow 5 6115 120 1 2 Red or Yellow 7 8100 105 2 3 Red or Yellow 9 10105 110 2 3 Red or Yellow 11 12</CODE></PRE>
For example here are 3 scenarios and the score I would want to come out.
<CODE>Var 1 = 108, Var 2 = 0.5, Var3 = Red, Score = 3Var 1 = 117, Var 2 = 1.7, Var 3 = Yellow, Score = 8Var 1 = 98, Var 2 = 2.0, Var 3 = Red, Score = N/A Scores ScoresVar 1 >= Var 1 < Var 2 >= Var 2 < Var 3 Red Yellow100 105 1 2 Red or Yellow 1 2105 110 0 1 Red or Yellow 3 4110 115 1 2 Red or Yellow 5 6115 120 1 2 Red or Yellow 7 8100 105 2 3 Red or Yellow 9 10105 110 2 3 Red or Yellow 11 12</CODE></PRE>