I have the following criteria and need a formula that wil return the associated point value.
I was provide this formula, but it adds a point if goals >= 100% and >= 125%. I need a return of points as shown below. I included my setup as well. Thank you in advance for any assistance.
=COUNTIF(E15:E17,">="&G14)+COUNTIF(E15:E17,">="&F14)
Goal 1 and 2 => 125% 5 pts
Goal 1 => 125% and goals 2 and 3 >= 100% 4 pts
Goal 1,2, and 3 => 100% 3 pts
2 goals => 100% 2 pts
Less than 2 goals met 1 pt
ColumnA B C D
Score 100% 125% Points
Goal 1 125%
Goal 2 100%
Goal 3 90% 2
I was provide this formula, but it adds a point if goals >= 100% and >= 125%. I need a return of points as shown below. I included my setup as well. Thank you in advance for any assistance.
=COUNTIF(E15:E17,">="&G14)+COUNTIF(E15:E17,">="&F14)
Goal 1 and 2 => 125% 5 pts
Goal 1 => 125% and goals 2 and 3 >= 100% 4 pts
Goal 1,2, and 3 => 100% 3 pts
2 goals => 100% 2 pts
Less than 2 goals met 1 pt
ColumnA B C D
Score 100% 125% Points
Goal 1 125%
Goal 2 100%
Goal 3 90% 2
