Another play could run along these lines ..

Assume you have in A1:B4 where
A1:B1 holds the players' names
A2:B2, A3:B3 etc holds the scores of each round's play

AA BB
50 60
60 50
60 60
etc

We could put in C2:

=IF(OR(A2="",B2=""),"",VLOOKUP(SIGN(A2-B2),{0,"Draw";1,"AA wins";-1,"BB
wins"},2,0))

and copy C2 down, to yield the results, viz.:

AA BB
50 60 BB wins
60 50 AA wins
60 60 Draw
etc

(Usually, there's also a "Draw" situation to cater for <g)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Dustywm" wrote in message
...
How do I set a Excel fomula for Win/Lose calculation please ie in a racing
betting record, entering W or L in a colunm.
Im usuing Excel 2002