Hi, I hope someone can help. I have a very basic knowledge of Excel, here goes.
I've created a game in excel. What i want to know is how to create a formula to change one value to another. To explain more it is a 'see who guesses closest' game, the scoring of the game works like this, if you get a correct answer you score 6, get within 1 and score 4, within 3 score 2, within 4 score 1 and anything above you lose a life. So want i want to do is be able to put the correct, 1,2 (one only) etc guesses into a box and have it converted in to the 6,4,2,1,out scores in another box thats keeping a running total.

Easy eh!