suertetres
New Member
- Joined
- Nov 8, 2023
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hi Everyone, I've searched, but may be calling it the wrong thing...I'm trying to assign a point range for a specific set of numbers and need help with the formula. The number after the = sign is the point i want to assign. Is there an if/then statement that could accomodate this large of a range?
The ranges are as follows:
>= 120% = 4
110.00%-119.99% = 3.5
90.00%-109.99%= 3
84%-89.99%= 2.5
75%-83.99%=2
67%-74.99%= 1.5
60%-66.99%= 1
55%-59.99%= .5
<54.99% = 0
The ranges are as follows:
>= 120% = 4
110.00%-119.99% = 3.5
90.00%-109.99%= 3
84%-89.99%= 2.5
75%-83.99%=2
67%-74.99%= 1.5
60%-66.99%= 1
55%-59.99%= .5
<54.99% = 0