Setting a Score based off a range of numbers (duplicate topic)

[danielstebbins]

I’m working on a project where I need to assign a score to a range of possible numbers. I’m not entirely sure where to start. I attached a screenshot of what I’ve been fiddling around with. Am I on the right track? Using the table below as an example, ideally I’d like to be able to assign any temperature input from 0-6 degrees as a 5, and any distance input from 1.1 to 1.2 miles as a 3. From there I’d like to add two scores (In this case 5 and 3) to reach a final score. Is there anyone who could help me out? Thanks

[tatiang]

I already offered a solution for this. If you’re having problems still, please add more details to the existing topic instead of starting a new one.

Setting a Score based off a range of numbers

I’m working on a project where I need to assign a score to a range of possible numbers. I’m not entirely sure where to start. I attached a screenshot of what I’ve been fiddling around with. Am I on the right track? Using the table below as an example, ideally I’d like to be able to assign any temperature input from 0-6 degrees as a 5, and any distance input from 1.1 to 1.2 miles as a 3. From there I’d like to add two scores (In this case 5 and 3) to reach a final score. Is there anyone who coul…

Also, there is no need to write that you need help in the topic title. It’s assumed that everyone posting a question needs help. I’ll change the title for you.