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

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.

you're probably best off PMing poster martymc1 with this question. he's the main IT expert around here

Ok Thanks for your help

=IF(C4 >0,D4*A4) or IF(C4 <0,-A4)

Like this??? now it just says #Value!

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.

IF(C4="W",D4*A4,-A4)

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!