I am creating an online tool and I understand the concept of what I need but not the exact formula to get me to where I want to be. I have two ranges of numbers the ranges will change but for this example we will use:
low a: 20,000
high a: 100,000
low b: 300
high b: 2000
So I will be given a number that fits inside of the range for "group a" and I need to find its equivalent for "group b" so if I was given the number 35,000 for group a what is the formula to find its counterpart for group b?