Forum Discussion
I need a little assistance from experts about this problem in EXCEL
Actually the problem is that I have a Cell that value occurs between 0% to 100%, so I want a function in another Cell to show a result starting from negative -10 to a positive 10 depending upon that ...
Riny_van_Eekelen wow,
Thank you very very much
How did you do it? I mean I still not get it but it worked.
WoW.
Amazing,
I didn't even expect someone would reply to this question.
Again thank you.
Good Job.
Noor646 Always glad to help out. Your question wasn't so difficult after all.
If the range from 0% (=0) to 100% (=1) matches a 20-point range of values from -10 to +10, this means that every point on your scale represents 5% (=0.05). Using the same logic but the other way around means that every percent represents 0.20 points (=20/100) on your 20-point scale.
My formula simply takes the percentage x 20 to find the number of points on the scale above the minimum of -10.