Scoring System

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.

HiDarksideEric
Welcome to the forum
This may be OK for you
Enter the tiles moved in cell G1 and see the points in cell E15

hi, DarksideEric, alternative with no helper column and tiles-points data table required.

Insert value in B2, check result in B4

Thank you for the help. Final question, could you explain the process a bit. I am good at coming up with mechanics and such but I am quite terribad at actual coding and such.

Hi DarksideEric
Look in the attached.
I have given a brief explanation based on my solution.
watersev's solution is very much more elegant.
Note I have also fixed a bug in my original posting so use this version of needs be.
barry

solution provided uses Excel functions only with no VB. The functions used are:
1. QUOTIENT - Returns the integer portion of a division between two supplied numbers. Example:
QUOTIENT(5,2)=2
2. MOD - Returns the remainder from a division between two supplied numbers. Example:
MOD(5,2)=1
3. VLOOKUP - Looks up a supplied value in the first column of a table, and returns the corresponding value from another column.
Any further details can be found in Excel help file.