If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please 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. If you need help to verify your account contact hello@boards.ie

Excel if/or function help

y0ssar1an22 · 2017-08-18 20:57:48

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…

Options

18-08-2017 9:57pm

#1

y0ssar1an22

Registered Users Posts: 16,168 ✭✭✭✭

Join Date: April 2013

Posts: 16054

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

Thanks for any help

0

Comments

Options
#2 18-08-2017 10:02pm
ligerdub

Registered Users Posts: 2,584 ✭✭✭

Join Date: July 2011

Posts: 2565

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.

0
Options
#3 18-08-2017 10:03pm
28064212

Registered Users Posts: 10,493 ✭✭✭✭

Join Date: May 2005

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

Boardsie Enhancement Suite - a browser extension to make using Boards on desktop a better experience (includes full-width display, keyboard shortcuts, dark mode, and more). Now available through your browser's extension store.
Firefox: https://addons.mozilla.org/addon/boardsie-enhancement-suite/
Chrome/Edge/Opera: https://chromewebstore.google.com/detail/boardsie-enhancement-suit/bbgnmnfagihoohjkofdnofcfmkpdmmce

0
Options
#4 18-08-2017 10:18pm
y0ssar1an22

Registered Users Posts: 16,168 ✭✭✭✭

Join Date: April 2013

Posts: 16054

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

0