Good day,
I know I can make this simpler but I am sending this out to the world of the company and need to keep it "concise".
I need to have a value "score" selected based on % given however, the options to pick the value "score" needs to be obtained using the range below
A B
<tbody>
</tbody>
I have tried IF(and( and IF(Or etc... nested if... The issue is the % is given based on completions - if the whole % of 76% then it would equal 15.
Any ideas you could share?
Thanks
I know I can make this simpler but I am sending this out to the world of the company and need to keep it "concise".
I need to have a value "score" selected based on % given however, the options to pick the value "score" needs to be obtained using the range below
A B
On Time | Score |
100% | 40 |
95-99% | 35 |
90-94% | 30 |
85-89% | 25 |
80-84% | 20 |
75-79% | 15 |
70-74% | 10 |
65-69% | 5 |
<64% | 0 |
<tbody>
</tbody>
I have tried IF(and( and IF(Or etc... nested if... The issue is the % is given based on completions - if the whole % of 76% then it would equal 15.
Any ideas you could share?
Thanks
Last edited: