formulas using text

B

bob

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
 
B

Biff

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 said:
Hi!

I have a file that does exactly what you want. Want a copy?

Biff
Click to expand...
 
B

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 said:
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
Click to expand...
 
Top