Thread: Formula help
View Single Post
  #2   Report Post  
Leo Heuser
 
Posts: n/a
Default

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