Forum Discussion

Noor646's avatar
Noor646
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 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.

excel

3 Replies

    • Noor646's avatar
      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's avatar
        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.

Resources