OK! So the issue of the day IS... I want to make cell (E4) return a number (1 through 20) based on a series or ranges which are entered in cell E9.
The ranges are...
1 to 99 = 1, 100 to 224 = 2, 225 to 274 = 3, 375 to 549 = 4, 550 to 749 = 5, 750 to 974 = 6, 975 to 1224 = 7, 1225 to 1499 =...