Hi everyone, I really hope i have posted this is the right section. Maths is not my greatest strength

But i find my self in a position needing help, and i have been thinking about this for who knows how long and i can't seem to come up with a formula to solve it.

I am creating a conversion tool for gaming reasons.

At the minute i have a number of mathematical equations that gives me a number in the range of 0-100. My problem now is; i need a way of condensing that number into a range of 50-100....

This is where it becomes confusing for me So i apoligise if it makes no sense, but hopefully it does lol

But a priority is needed, (50 is bad, 75 is good, 80 is great, 90 best, 100 perfect) so if the number in the original range is 49 i can't just condess it to be 75/100, because that would mean it is a good stat. When it is average.... So when condenssing the range of numbers a priority is needed, 0 the worst, 100 the best. So 50-55 would be anything from 0-30 from the original list, 56-60 being 31-49 from the original, then 61-65 / 50-59. 66-70 / 60-70..... Then anything above that i would like to be coverted as it appears in the original....

If it helps i am using Excel to create my converter....

Once again i hope i can get some help and i can only apoligise if this is a completely "stupid" question.

Thank You

ja_santacruz