Hi,

Or you can get cute:

Enter the formula
=B3-C3
and copy it down
Select the range and apply the custom format:
"W";"L";"T"
Choose Format, Cells, Number tab, Custom and enter the above code in the
Type box.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Malcolm Austin" wrote:

HI,
this is sure to be easy to those in the know!

Using Excel 2000.

I have to compare scores in two columns (B & C) and wish to have in my
table
either W or L for win or lose.

So in B3 (for) there is 21
and in C3 (against) there is 15

So the table should show a W, but must show an L if the scores are reversed.

Not sure which function to use (tried IF but could not get it to do two
meanings)

So what should I use and how can I write it please?

Malcolm...