Forum Discussion

Copper Contributor

Jan 22, 2020

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 ...

excel

Riny_van_Eekelen

Platinum Contributor

Jan 22, 2020

Noor646

Assuming your percentage is in A1, it could be as simple as:

=A1*20-10

Noor646
Copper Contributor
Jan 25, 2020
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.
- Riny_van_Eekelen
  Platinum Contributor
  Jan 25, 2020
  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.