I'm looking for a formula that will assign a score based on a result in a cell and where that result falls into a table.
For example, my table could be:
0 to 10 = 1 point
11 to 20 = 2 points
21 to 30 = 3 points
If a particular cell has 13 in it, I want another cell to equal 2
This is a simplified version of my actual spreadsheet but I have attached a copy of my actual workbook. I've highlighted the cellin which I need the formula and the tables are on a seperate tab.
Please let me know if you can help..
Thank you!
Bookmarks