Hi, I'm trying to get a scoring system to work in Excel and I'm not quite sure of what formula to use. My scoring system is based on a staggered tiles moved = points with 1 tile = 10 points, 10 tiles = 1 point. I have my tiles and points in separate columns like this:

1 10
2 9
3 8

etc

I need to have the scoring system to recognize that, if the player were to move 82 tiles for example that they would receive 17 points (8 points for 80 tiles, 9 points for 2 tiles).

I would also need to be able to make the formula work for if the player moves over 100 tiles.

Thank you in advance for any help.