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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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",""))))))
 
Upvote 0
=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
 
Upvote 0
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.
 
Upvote 0
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}),"")
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

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
Back
Top