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 08:57PM

#1

y0ssar1an22

Registered Users, Registered Users 2, Paid Member Posts: 20,364 ✭✭✭✭

Join Date: April 2013

Posts: 20247

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

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

Registered Users, Registered Users 2 Posts: 11,106 ✭✭✭✭

Join Date: May 2005

Posts: 10362
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 09:18PM

y0ssar1an22

Registered Users, Registered Users 2, Paid Member Posts: 20,364 ✭✭✭✭

Join Date: April 2013

Posts: 20247

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

0