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