+ Reply to Thread
Results 1 to 2 of 2

Help with TRUE/FALSE formula

  1. #1
    Registered User
    Join Date
    09-28-2014
    Location
    Denmark
    MS-Off Ver
    2003
    Posts
    8

    Help with TRUE/FALSE formula

    Hi
    I am fairly new to Excel but have a general understanding of the functions and basic formulas. I am currently making a spreadsheet for myself to help me keep track of sports bets as a test for a system I would like to try. So I have made this spreadsheet with 10 games that are played today and I am looking for a formula that can tell me wether or not the bet was a win or loss.
    As you can see in my spreadsheet, I have got a few different values. Home and Away states the odds on the Home and Away team, Bet Home and Bet away is the amount of cash being put on either the Home or Away team, Win Home and Win Away is a potential Win for the Home or Away side. Bet Total is the total amount of cash being bet on the Home and Away side in one match and with a grand total in the bottom.
    Now, Outcome is blank because I need help with a formula to tell me if the game was either a win or a loss.
    Now, I want to be able to plot in a (H)ome, (A)way or (L)oss in the outcome cell which in turn calculates if I have won a bet on the Home or Away side or if I lost the bet. So if I plot in an A in the WBA vs Burnley Outcome cell, I would want it to calculate my Away earnings minus the Bet Total for that match. I then want the Outcome text to be written in either green (for a win) or red (for a loss).

    Any help would be greatly appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Help with TRUE/FALSE formula

    Your sample sheet is not complete. Please fill in and add your sample inputs in column K and I imagine your desired results in column L as well. Show us the whole run of data and we can offer immediate exact suggestions. Thanks.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  2. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  3. Excel 2007 : If formula using True and False
    By casdaq in forum Excel General
    Replies: 2
    Last Post: 05-06-2011, 03:59 PM
  4. Excel True and False formula help
    By sphex in forum Excel General
    Replies: 9
    Last Post: 03-14-2011, 10:32 PM
  5. Replies: 3
    Last Post: 03-15-2006, 11:00 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