Help Needed Please...
I have a column represents a set of numbers (including negative value), and im trying to map it with 9 point scale
The Value Range is
9 =12
7 = 3
5 = -6
3 = -14
1 = -21
Need help to seek answers if the value to map the range is 12.4, 6.8, -6.3, -8.5, -15 and so on.
Not sure how to do the negative value in excel
Thanks in advance for helping me out here!
I have a column represents a set of numbers (including negative value), and im trying to map it with 9 point scale
The Value Range is
9 =12
7 = 3
5 = -6
3 = -14
1 = -21
Need help to seek answers if the value to map the range is 12.4, 6.8, -6.3, -8.5, -15 and so on.
Not sure how to do the negative value in excel
Thanks in advance for helping me out here!