Thread: WHICH FUNCTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Malcolm Austin Malcolm Austin is offline
external usenet poster
 
Posts: 15
Default 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...