I need a little assistance from experts about this problem in EXCEL

[Noor646]

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 percentage. like if I have 0% in that cell, it should be negative -10 in this one and if I have 100% in there, it should be positive 10 and all other percentages respectively. I hope you understand what i want to say.

[#2]

@Noor646 

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

=A1*20-10

[#3]

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

[#4]

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