Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on [email protected] for help. Thanks :)
Hello All, This is just a friendly reminder to read the Forum Charter where you wish to post before posting in it. :)
Hi all, The AutoSave Draft feature is now disabled across the site. The decision to disable the feature was made via a poll last year. The delay in putting it in place was due to a bug/update issue. This should serve as a reminder to manually save your drafts if you wish to keep them. Thanks, The Boards Team.
Hello all! This is just a quick reminder to ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere.

Excel if/or function help

  • 18-08-2017 8:57pm
    #1
    y0ssar1an22
    Registered Users Posts: 13,196 ✭✭✭✭ y0ssar1an22


    Hey guys,

    hope this is in the correct place. I'm looking for some help with an excel sheet I'm trying to create to track bets/winnings.

    see attached image.

    What i want to do is along the lines of:

    if result = w, then win = odds * stake; if result = L, then win = 0

    I just cant translate that into excel language :o

    Thanks for any help


Comments

  • #2
    ligerdub
    Registered Users Posts: 2,579 ✭✭✭ ligerdub


    Only the win outcome is relevant really so I'd suggest entering the following in the financial outcome:

    =IF(E2="w",C2*D2,0)

    where c2 = Odds, d2 = stake

    I've not assumed the stake back.

    I have merely multiplied the odds by the stake here.


  • #3
    28064212
    Registered Users Posts: 10,135 ✭✭✭✭ 28064212


    Assuming "Odds" is column B: 
    =IF(B1="L", 0, IF(B1="W", C1*D1,""))

    Boardsie Enhancement Suite - a browser extension to make using post-migration Boards on desktop a better experience (includes full-width display, keyboard shortcuts, and a dark mode setting)



  • #4
    y0ssar1an22
    Registered Users Posts: 13,196 ✭✭✭✭ y0ssar1an22


    thanks a million guys. this will make losing money that bit more fun! plus i also learnt something :)


Advertisement