What I want to do is take a rating value I have in row "D" (0-5) and convert each number to a specific value (0=1290, 1=1550, etc). I have these values stored in cells "I9-I14". Then in Column "L" I want to have a formula that uses the value (ex. "(c1-D1)/3500"). In that example D1 has the rating of 2, but in the formula I want that to mean 1550. Is this possible?

The values of the rating scale might change over time as I collect more data to make it more accurate to my specific need. So I would rather use a rating scale number in the formula so if I have to change the value it will adjust without me having to go into each cell to change it.