+ Reply to Thread
Results 1 to 2 of 2

Calculate based on different values

  1. #1
    Registered User
    Join Date
    09-27-2009
    Location
    Dublin
    MS-Off Ver
    MS 365
    Posts
    97

    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.

    https://docs.google.com/spreadsheets...KO8/edit#gid=0

    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. #2
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Calculate based on different values

    Hi David,

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate based on a range of values
    By JennOlsen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2018, 12:20 PM
  2. Replies: 12
    Last Post: 08-05-2015, 05:15 PM
  3. Need to calculate values based on category
    By JStans12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2014, 02:09 PM
  4. [SOLVED] Calculate values in col B based on value in col B but only calculate final 5 instances
    By arnoldd99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2013, 11:53 AM
  5. [SOLVED] Code to calculate values based on %
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2013, 05:25 AM
  6. Calculate Values in a row based on value of first column
    By travisg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2013, 01:39 PM
  7. Calculate the Range based on certain values
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 05-14-2013, 08:09 AM

Bookmarks

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