Thread: Formula help
View Single Post
  #1   Report Post  
George Gee
 
Posts: n/a
Default Formula help

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