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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Hi George
You're welcome and thanks for the feedback :-) Should the day come, this formula can be used regardless of the number of digits. The number of spaces between the two results don't matter. =IF(VALUE(LEFT(G7,FIND(" ",G7))) VALUE(MID(G7,FIND(" ",G7),1000)),"Win", IF(VALUE(LEFT(G7,FIND(" ",G7)))< VALUE(MID(G7,FIND(" ",G7),1000)),"Lose","Draw") Entered as one line. LeoH "George Gee" skrev i en meddelelse ... 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 |
#5
|
|||
|
|||
Hi Leo Have noted your update, many thanks once again. -- George *Leo Heuser* has posted this message: Hi George You're welcome and thanks for the feedback :-) Should the day come, this formula can be used regardless of the number of digits. The number of spaces between the two results don't matter. =IF(VALUE(LEFT(G7,FIND(" ",G7))) VALUE(MID(G7,FIND(" ",G7),1000)),"Win", IF(VALUE(LEFT(G7,FIND(" ",G7)))< VALUE(MID(G7,FIND(" ",G7),1000)),"Lose","Draw") Entered as one line. LeoH "George Gee" skrev i en meddelelse ... 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 |
#6
|
|||
|
|||
My pleasure :-)
LeoH "George Gee" skrev i en meddelelse ... Hi Leo Have noted your update, many thanks once again. -- George |
Reply |
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) |