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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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

ADVERTISEMENT

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,209
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,147,846
Messages
5,743,521
Members
423,801
Latest member
paulj4177

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