Formula

andyk68

New Member
Joined
Jan 22, 2005
Messages
3
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
Joined
Oct 28, 2002
Messages
771
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
Joined
Oct 28, 2002
Messages
771
=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
Joined
Jan 22, 2005
Messages
3
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.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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}),"")
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top