I'm trying to create a score. I've got 5 criteria worth 20 points each on a sliding scale. 0-1000 = 5 points, 1001-5000=10 points, 5001-10000=15 points, 10001+ = 20 points.
I'm lost. Please help.
I'm trying to create a score. I've got 5 criteria worth 20 points each on a sliding scale. 0-1000 = 5 points, 1001-5000=10 points, 5001-10000=15 points, 10001+ = 20 points.
I'm lost. Please help.
Here, try this:
=LOOKUP(A1,{0,1000,5000,10000},{5,10,15,20})
works great! thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks