# Formula

#### andyk68

##### New Member
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!

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

#### d0wnt0wn

##### Well-known Member
how many rounds would there be????? here is a formula to get you going....

=IF(A1=6,6,IF(A1=5,4,IF(A1=4,3,IF(A1=3,2,IF(A1=2,1,IF(A1=0,"lost life",""))))))

#### d0wnt0wn

##### Well-known Member
=IF(A1=6,6,IF(A1=5,4,IF(A1=4,3,IF(A1=3,2,IF(A1=2,1,IF(A1>2,"lost life",""))))))

sorry should have been like this

#### andyk68

##### New Member
Thx downtown. there are 20 rounds, 1 guess per round

#### andyk68

##### New Member
That formula works great. What i need now is a way of making the box that the formula was created for blank until a score has been put in. At the moment all the score boxes default to 6 when the box it takes its info from is blank or empty.

##### MrExcel MVP
andyk68 said:
That formula works great. What i need now is a way of making the box that the formula was created for blank until a score has been put in. At the moment all the score boxes default to 6 when the box it takes its info from is blank or empty.

If that interpretation is right...

=IF((A1>1,A1<=6),LOOKUP(A1,{2,3,4,5,6},{1,2,3,4,6}),"")

#### d0wnt0wn

##### Well-known Member
andy if you would like to you can email me your worksheet at kenbrown@arbutusroofing.com and I can look at it for you.... easier to do than to try and guess exactly what it is you are doing

Replies
3
Views
245
Replies
9
Views
415
Replies
0
Views
589
Replies
2
Views
197
Replies
0
Views
508

1,181,820
Messages
5,932,255
Members
436,830
Latest member
Sochen

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back