|
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 |
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 |
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 |
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 |
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 |
|
|
| All times are GMT +1. The time now is 12:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com