Someone please explain the formula i need (help)
Join Date: Apr 2016
Posts: 16
Hi all!!
It has been a long time since i used excel (10 years!). I would like to do a running P/L, ROI, Bet record chart etc.
My Cells run as follows
A---Stake (Where A2 is £50)
B---Bet (Where B2 is Ostapenko French open final)
C---W/L (Where C2 is 'W') ,,,,,this refers to Win or Loss
D---Price (Where D2 is 4),,,,,,odds of the outcome
E---Returns (Where E2 should = A2*D2 when C2 is 'W' and -A2 when C2 is 'L')
This is where i'm struggling.. I basically want the formula that would give me stake x price when it wins and 0 minus stake when it Loses (I hope this makes sense).
The formula i tried, was =IF(C4 =W,D4*A4) or IF(C4 = L,-A4)
Which is obviously wrong as i'm a complete noob!
Then next cells are: (which is not really necc)
F.....Profit/Loss..(Where F2 = E3 - A2)
G.... Acc P/L ...(Where G3 = G2 + F3)
H.... ROI....(etc)
I hope someone can help me without taking the piss out of me for being so stupid.
Thanks
Join Date: Jun 2005
Posts: 43,152
Not supposed to be here but it's if c4>0 and c4<0 to replace c4=w and c4=l, those arguments will just give you errors.
Join Date: Apr 2017
Posts: 13,844
you're probably best off PMing poster martymc1 with this question. he's the main IT expert around here
Join Date: Apr 2016
Posts: 16
Join Date: Apr 2016
Posts: 16
=IF(C4 >0,D4*A4) or IF(C4 <0,-A4)
Like this??? now it just says #Value!
Join Date: Jun 2005
Posts: 43,152
Is there something in c4,a4 and d4? You can also add an argument if there are blanks or zeros. I think the arguments are actually simpler, if (c4>0,d4*a4,-a4) is all you need. Argument and then argument if correct and argument if not correct. That or argument won't do anything.
Join Date: Apr 2005
Posts: 21,439
Join Date: Apr 2016
Posts: 16
YEY!!
this one works =IF(C4>0,D4*A4,-A4) Thanks , so i will just put 1 for win and 0 for loss.
Rather than 'W' or 'L'
thanks so much!