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
|