WHICH FUNCTION
 

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...

WHICH FUNCTION
 

=IF(B3=C3,"T",IF(B3C3,"W","L"))
--
Gary''s Student - gsnu2007k

WHICH FUNCTION
 

Hi,

Try this

=IF(B3C3,"W","L")

But that won't cater for a draw which this will

=IF(B3C3,"W",IF(B3<C3,"L","D"))

Mike


"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...

WHICH FUNCTION
 

Try this in D3:

=IF(OR(C3="",B3=""),"",IF(B3C3,"W",IF(C3B3,"L"," D")))

This also caters for equal scores (D for draw), and for empty cells in
either C3 or B3. Just copy it down as required.

Hope this helps.

Pete

On Jan 10, 12:53*pm, "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...

WHICH FUNCTION
 

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...