Hi Leo

Many thanks for that, it works fine.
It would be a rare day indeed for a score of more than 9 in English league
football!

George
--

*Leo Heuser* has posted this message:

Hi George

One way assuming one digit for either result:

=IF(LEFT(G7,1)RIGHT(G7,1),"Win",IF(LEFT(G7,1)<RIG HT(G7,1),"Lose","Draw"))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"George Gee" skrev i en meddelelse
...
Hi all

In cell G7 I have a football score, (user input) in the form of
(e.g.) 2 2 (note the space between the two numbers).

In G6 I want a formula that displays "Win" "Lose" or "Draw",
dependant upon
the input sco

So if the leftmost number is greater than the rightmost number,
"Win".

If the leftmost number is smaller than the rightmost number "Lose".

If the leftmost number is equal to the rightmost number "Draw".

Many thanks for your time.

--
George