Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |