# Calculate based on different values

1. ## Calculate based on different values

Hi, All.

I'm trying to make a sheet that will automatically calculate winnings. I'm trying to get a Zoom staff night at the races.. and can't get this working.

The idea:

I have the odds in the Red border box.
I add what people have bet on in the green board box. They can bet up to 3 times on each race.

The results of the race are entered into the blue box.

If the number in the blue box matches any where in the green box it's a winner and we need to calculate your winnings.
So in this case we've a few winners.
So i'd like to automatically fill in the total win section. The second I fill in the blue box with the winning number it should fill in the "Total Win" section.

So it's needs to
If E14= Win multiply F14*C4+F14 - I manually entered this for the sample.

But because traps 1 to 6 could win the range would need to be bigger.

I'm not even sure if this can be done. Just hoping it can be.

thanks.

2. ## Re: Calculate based on different values

Hi David,

Have at the "New" tab and see if this works for you.

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