Use > or < for hyphenated cell

[honkin]

hi

Is it possible to check greater than or less than in a cell with a hyphenated number? I do not wish to create a further helper column unless that is the only way to achieve what I am after.

I have a sheet with football scores in it and they come like this 1-0, 2-2, 2-1 etc. Is it possible in a formula to check if one part is higher or lower than the other part? The idea is to be able to automate adding W (win), L (loss) or D (draw) in the results column

I guess in plain English, it would read something like this; IF number to the right of the hyphen is > than number to the left of the hyphen, L, otherwise W. Draw is not really required, so just W & L

How would this be achieved?

cheers in advance

 

[BenMiller]

=IF(--LEFT(A1,FIND("-",A1)-1)>--RIGHT(A1,LEN(A1)-FIND("-",A1)),"W",IF(--LEFT(A1,FIND("-",A1)-1)=--RIGHT(A1,LEN(A1)-FIND("-",A1)),"D","L"))