Compare number before dash to number after dash

[honkin]

I have a sheet which keeps records of football (soccer) matches all over Europe. The scores come in like this 1-0, 2-1 and so on, but I'd like to be able to have the results column automatically update based on the native score, without using a helper column.

Is there a way to do something like , IF before the - is >= after the dash, then W, L?

Thanks in advance

 

[jtakw]

Hi,

Something like this:

Book3.xlsx
	A	B
1	1-0	W
2	2-1	W
3	2-5	L
4	11-3	W
Sheet1066

Cell Formulas
Range	Formula
B1:B4	B1	=IF(LEFT(A1,FIND("-",A1)-1)+0>MID(A1,FIND("-",A1)+1,99)+0,"W","L")

 

[V51773]

Try this
=IF(LEFT(A2,FIND("-",A2)-1)>REPLACE(A2,1,FIND("-",A2),""),"W","L")

 

[jtakw]

@V51773

You'll need to convert the LEFT and REPLACE results to Real Numbers for it to work correctly. (I.e. *1, +0, -- )

 

[V51773]

@V51773

You'll need to convert the LEFT and REPLACE results to Real Numbers for it to work correctly. (I.e. *1, +0, -- )

Thank you for your guidance wasnt able to take that into account

 

[honkin]

Hi,

Something like this:

Book3.xlsx
	A	B
1	1-0	W
2	2-1	W
3	2-5	L
4	11-3	W
Sheet1066

Cell Formulas
Range	Formula
B1:B4	B1	=IF(LEFT(A1,FIND("-",A1)-1)+0>MID(A1,FIND("-",A1)+1,99)+0,"W","L")

cheers jtakw.

That formula seems to work fine. So if I want it to work in reverse, I figure I just change the > to < and if I want to do draws it would be = and if I do NOT want draws it would be <> yeah?

Just trying to have a way that will work in the various sheets, some picking the home team to win, some picking the away team, some picking the draw and some picking the draw NOT to happen.

Just on testing, it works with <> on the sheet which picks the draw NOT to happen, so I think this is perfect.

Thanks so much

 

[jtakw]

cheers jtakw.

That formula seems to work fine. So if I want it to work in reverse, I figure I just change the > to < and if I want to do draws it would be = and if I do NOT want draws it would be <> yeah?

Just trying to have a way that will work in the various sheets, some picking the home team to win, some picking the away team, some picking the draw and some picking the draw NOT to happen.

Just on testing, it works with <> on the sheet which picks the draw NOT to happen, so I think this is perfect.

Thanks so much

Yes, you should be able to achieve those results as you described.

 

[Phuoc]

If cell A2 is 2-2, what do you want the result to be?

.

 

[honkin]

If cell A2 is 2-2, what do you want the result to be?

.

Cheers Phuoc
Depends on what the model is looking at, but I have everything I need from the post #2 above. Simply changing the > to < or = or <> will cover most things. The only thing I can yet do is over or under a certain number like 2 for example. I'll start another thread for that, though

Thanks again