Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas using text
hello
First i dont even know is this is possible orif i am using the right program but...i would like to set excell for a football pool where each players pick is matched against the outcome of that game and will enter the value win or loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not error proof also i would like a function add up all the win and losses to get a win loss record for that week i.e. 11-5 if thats possible you are a god and i am the happiest person alive -- bob |
#2
|
|||
|
|||
Hi!
I have a file that does exactly what you want. Want a copy? Biff "bob" wrote in message ... hello First i dont even know is this is possible orif i am using the right program but...i would like to set excell for a football pool where each players pick is matched against the outcome of that game and will enter the value win or loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not error proof also i would like a function add up all the win and losses to get a win loss record for that week i.e. 11-5 if thats possible you are a god and i am the happiest person alive -- bob |
#3
|
|||
|
|||
Well, it doesn't do EXACTLY what you want....
Instead of returning a "Win" or "Loss" I use conditional formatting to highlight the wins or losses. My file is for the NFL. It's already setup for the upcoming season. Each week the people in the pool make their picks then each week is summarized and a running total is calculated along with a winning %. I also have it weighted because each week the number of people that participate changes. That way, if someone only picks 1 week and goes 16-0 with a winning percentage of 1.000 they will not win over someone who picks every week and has a lower winning percentage. Biff "Biff" wrote in message ... Hi! I have a file that does exactly what you want. Want a copy? Biff "bob" wrote in message ... hello First i dont even know is this is possible orif i am using the right program but...i would like to set excell for a football pool where each players pick is matched against the outcome of that game and will enter the value win or loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not error proof also i would like a function add up all the win and losses to get a win loss record for that week i.e. 11-5 if thats possible you are a god and i am the happiest person alive -- bob |
#4
|
|||
|
|||
heck yea ill take it !!!!!
this is for a complete season each person will be in it each week so if there are any changes you might think i need to make ket me know!!!and thanks for the help i am sooo happy:) -- bob "Biff" wrote: Well, it doesn't do EXACTLY what you want.... Instead of returning a "Win" or "Loss" I use conditional formatting to highlight the wins or losses. My file is for the NFL. It's already setup for the upcoming season. Each week the people in the pool make their picks then each week is summarized and a running total is calculated along with a winning %. I also have it weighted because each week the number of people that participate changes. That way, if someone only picks 1 week and goes 16-0 with a winning percentage of 1.000 they will not win over someone who picks every week and has a lower winning percentage. Biff "Biff" wrote in message ... Hi! I have a file that does exactly what you want. Want a copy? Biff "bob" wrote in message ... hello First i dont even know is this is possible orif i am using the right program but...i would like to set excell for a football pool where each players pick is matched against the outcome of that game and will enter the value win or loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not error proof also i would like a function add up all the win and losses to get a win loss record for that week i.e. 11-5 if thats possible you are a god and i am the happiest person alive -- bob |
#5
|
|||
|
|||
Ok, just let me know where to send the file.
Biff "bob" wrote in message ... heck yea ill take it !!!!! this is for a complete season each person will be in it each week so if there are any changes you might think i need to make ket me know!!!and thanks for the help i am sooo happy:) -- bob "Biff" wrote: Well, it doesn't do EXACTLY what you want.... Instead of returning a "Win" or "Loss" I use conditional formatting to highlight the wins or losses. My file is for the NFL. It's already setup for the upcoming season. Each week the people in the pool make their picks then each week is summarized and a running total is calculated along with a winning %. I also have it weighted because each week the number of people that participate changes. That way, if someone only picks 1 week and goes 16-0 with a winning percentage of 1.000 they will not win over someone who picks every week and has a lower winning percentage. Biff "Biff" wrote in message ... Hi! I have a file that does exactly what you want. Want a copy? Biff "bob" wrote in message ... hello First i dont even know is this is possible orif i am using the right program but...i would like to set excell for a football pool where each players pick is matched against the outcome of that game and will enter the value win or loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not error proof also i would like a function add up all the win and losses to get a win loss record for that week i.e. 11-5 if thats possible you are a god and i am the happiest person alive -- bob |
#6
|
|||
|
|||
|
#7
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show text after formulas | Excel Discussion (Misc queries) | |||
How do I convert cells containing formulas to text (value returned | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do you average text formulas?? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |