# Formula to bring back value based on scoring value

1. ## Formula to bring back value based on scoring value

Hi,

I'm setting up a competition at work for the upcoming Euros and looking to make my life a little bit easier when running it.

It's a score prediction game and the below are the scoring rules we're using:

3 points - Outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 2 - 0 Turkey v Italy, this would result in 3 points as the person got the correct outcome in picking Turkey to Win).
5 points - Team Score Correct (I.e. Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 0 Turkey v Italy, this would result in 5 points as the person got the correct outcome in picking Turkey to Win but also how many goals Turkey would win).
7 points - Correct Score (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 1 Turkey v Italy, this would result in 7 points as they've correctly picked the correct final score).
0 points - Incorrect outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 0 - 2 Turkey v Italy, this would result in 0 points as they've incorrectly picked the correct final outcome).

Is there any quick way of doing a formula which could populate the points column?

Thanks,

MW

2. ## Re: Formula to bring back value based on scoring value

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new, I will provide the link for you today: https://www.mrexcel.com/board/thread...value.1167841/.)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1