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…

18-08-2017 09:57PM

#1

y0ssar1an22

Registered Users, Registered Users 2 Posts: 18,875

✭✭✭✭

Join Date: April 2013

Posts: 18759

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

#2 18-08-2017 10:02PM

ligerdub

Registered Users, Registered Users 2 Posts: 2,585

✭✭✭

Join Date: July 2011

Posts: 2566

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
#3 18-08-2017 10:03PM
28064212

Registered Users, Registered Users 2 Posts: 11,005

✭✭✭✭

Join Date: May 2005

Posts: 10265
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
#4 18-08-2017 10:18PM

y0ssar1an22

Registered Users, Registered Users 2 Posts: 18,875

✭✭✭✭

Join Date: April 2013

Posts: 18759

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

0

Welcome!

It looks like you're new here. Sign in or register to get started.