Archive for forum.sports-pro.co.uk A discussion forum devoted to people who want to talk about sports and sports betting! People without a sense of humour need not apply!!
I have a question on spreadsheets because i have forgotten the answer and i cannot find it on any spreadsheets i have got at the moment.
To make the spreadsheet easier for this competion i want to do a box where i can either put a W (win) or L (lost) and then when calculating i should be able to do a sum like
when E5 = W multiply E3(stake) & E4(odds) to give E6
or
when E5 = L minus E3 from E6
I just cannot remember how to do the =SUM for this and would apreciate it if anyone can put it up
Cheers
JDFUNKY
YAIYAM wrote:
I have a question on spreadsheets because i have forgotten the answer and i cannot find it on any spreadsheets i have got at the moment.
To make the spreadsheet easier for this competion i want to do a box where i can either put a W (win) or L (lost) and then when calculating i should be able to do a sum like
when E5 = W multiply E3(stake) & E4(odds) to give E6
or
when E5 = L minus E3 from E6
I just cannot remember how to do the =SUM for this and would apreciate it if anyone can put it up
Cheers
Won't it be the IF function, i.e. IF(E5="W", E3*E4) - something like that anyway!!??
YAIYAM
JDFUNKY wrote:
YAIYAM wrote:
I have a question on spreadsheets because i have forgotten the answer and i cannot find it on any spreadsheets i have got at the moment.
To make the spreadsheet easier for this competion i want to do a box where i can either put a W (win) or L (lost) and then when calculating i should be able to do a sum like
when E5 = W multiply E3(stake) & E4(odds) to give E6
or
when E5 = L minus E3 from E6
I just cannot remember how to do the =SUM for this and would apreciate it if anyone can put it up
Cheers
Won't it be the IF function, i.e. IF(E5="W", E3*E4) - something like that anyway!!??
yep that works , so would the whole SUM then be
IF(E5="W", E3*E4) or IF (E5="L", E6-E3)
JDFUNKY
YAIYAM wrote:
JDFUNKY wrote:
YAIYAM wrote:
I have a question on spreadsheets because i have forgotten the answer and i cannot find it on any spreadsheets i have got at the moment.
To make the spreadsheet easier for this competion i want to do a box where i can either put a W (win) or L (lost) and then when calculating i should be able to do a sum like
when E5 = W multiply E3(stake) & E4(odds) to give E6
or
when E5 = L minus E3 from E6
I just cannot remember how to do the =SUM for this and would apreciate it if anyone can put it up
Cheers
Won't it be the IF function, i.e. IF(E5="W", E3*E4) - something like that anyway!!??
yep that works , so would the whole SUM then be
IF(E5="W", E3*E4) or IF (E5="L", E6-E3)
Just tried it and it doesn't work - not sure how to put the 2 functions into the 1 cell, you could do 2 columns alongside each other, 1 IF(E5=W, etc) and the other IF(E5=L, etc)?
There is a way, just can't remember the function !!!
YAIYAM
JDFUNKY wrote:
YAIYAM wrote:
JDFUNKY wrote:
YAIYAM wrote:
I have a question on spreadsheets because i have forgotten the answer and i cannot find it on any spreadsheets i have got at the moment.
To make the spreadsheet easier for this competion i want to do a box where i can either put a W (win) or L (lost) and then when calculating i should be able to do a sum like
when E5 = W multiply E3(stake) & E4(odds) to give E6
or
when E5 = L minus E3 from E6
I just cannot remember how to do the =SUM for this and would apreciate it if anyone can put it up
Cheers
Won't it be the IF function, i.e. IF(E5="W", E3*E4) - something like that anyway!!??
yep that works , so would the whole SUM then be
IF(E5="W", E3*E4) or IF (E5="L", E6-E3)
Just tried it and it doesn't work - not sure how to put the 2 functions into the 1 cell, you could do 2 columns alongside each other, 1 IF(E5=W, etc) and the other IF(E5=L, etc)?
There is a way, just can't remember the function !!!
I thought about having 2 boxes but then i would not need to use the IF function because i could either just enter a figure in one box or not enter it in another and i would get what i want anyway, i was really trying to cut it to 1 box thats why i asked
cheers anyway
Flatz
YAIYAM wrote:
JDFUNKY wrote:
YAIYAM wrote:
JDFUNKY wrote:
YAIYAM wrote:
I have a question on spreadsheets because i have forgotten the answer and i cannot find it on any spreadsheets i have got at the moment.
To make the spreadsheet easier for this competion i want to do a box where i can either put a W (win) or L (lost) and then when calculating i should be able to do a sum like
when E5 = W multiply E3(stake) & E4(odds) to give E6
or
when E5 = L minus E3 from E6
I just cannot remember how to do the =SUM for this and would apreciate it if anyone can put it up
Cheers
Won't it be the IF function, i.e. IF(E5="W", E3*E4) - something like that anyway!!??
yep that works , so would the whole SUM then be
IF(E5="W", E3*E4) or IF (E5="L", E6-E3)
Just tried it and it doesn't work - not sure how to put the 2 functions into the 1 cell, you could do 2 columns alongside each other, 1 IF(E5=W, etc) and the other IF(E5=L, etc)?
There is a way, just can't remember the function !!!
I thought about having 2 boxes but then i would not need to use the IF function because i could either just enter a figure in one box or not enter it in another and i would get what i want anyway, i was really trying to cut it to 1 box thats why i asked
cheers anyway
Yaiyam,
Try this. . . =IF(E5="W",E3*E4,-E3)
Where E3 is initial stake (£100 or £150)
E4 is the decimal odds (e.g. 5/2 is written as 3.5)
E5 is "W" if won, or "L" if lost (although if this is left blank or anything other than a "W" is put in, it will ignore it and put it down as if it was a loss).
E6 is the total returns, including stake.
I hope this is what you want but give me a shout if you need any more assistance.
Cheers
Flatz
YAIYAM
Flatz wrote:
YAIYAM wrote:
JDFUNKY wrote:
YAIYAM wrote:
JDFUNKY wrote:
YAIYAM wrote:
I have a question on spreadsheets because i have forgotten the answer and i cannot find it on any spreadsheets i have got at the moment.
To make the spreadsheet easier for this competion i want to do a box where i can either put a W (win) or L (lost) and then when calculating i should be able to do a sum like
when E5 = W multiply E3(stake) & E4(odds) to give E6
or
when E5 = L minus E3 from E6
I just cannot remember how to do the =SUM for this and would apreciate it if anyone can put it up
Cheers
Won't it be the IF function, i.e. IF(E5="W", E3*E4) - something like that anyway!!??
yep that works , so would the whole SUM then be
IF(E5="W", E3*E4) or IF (E5="L", E6-E3)
Just tried it and it doesn't work - not sure how to put the 2 functions into the 1 cell, you could do 2 columns alongside each other, 1 IF(E5=W, etc) and the other IF(E5=L, etc)?
There is a way, just can't remember the function !!!
I thought about having 2 boxes but then i would not need to use the IF function because i could either just enter a figure in one box or not enter it in another and i would get what i want anyway, i was really trying to cut it to 1 box thats why i asked
cheers anyway
Yaiyam,
Try this. . . =IF(E5="W",E3*E4,-E3)
Where E3 is initial stake (£100 or £150)
E4 is the decimal odds (e.g. 5/2 is written as 3.5)
E5 is "W" if won, or "L" if lost (although if this is left blank or anything other than a "W" is put in, it will ignore it and put it down as if it was a loss).
E6 is the total returns, including stake.
I hope this is what you want but give me a shout if you need any more assistance.
Cheers
Flatz
I am sure i must have taught you that at some point
SkankyMinga
I was asked to move the "clutter" from the Champions League thread. As I saw it as being quite useful info I have moved it to "betting help" and then it can be used for future reference.
!!!