Two values in one cell?

Hello,

I'm making a football league table for my IT Coursework and I need to know how I can have two different values in one cell, say for example:

2-1 was in cell K3, how would I include the 2 in one part of the formula and the 1 in another part of the formula.

I need this in for an IF function.

Thanks a lot.

I'm sorry for being a bit thick, but I don't understand the V Look up formula.

http://tinypic.com/view.php?pic=7wsygdd&s=1

See cell K3, it displays the score 2-1 to Arsenal. I want to have both values in the same cell. I want to have it as an IF function so if the 2 on the left hand side is above the 1 on the right hand side is gives arsenal 3 points and Fulham 0.

So basically an IF Function with two values from one cell.

Can you tell him how this is done please.

Thanks.

then string it all together like this
=IF((LEFT(K3,FIND("-",K3)-1)+0)>(MID(K3,FIND("-",K3)+1,255)+0),3,IF((LEFT(K3,FIND("-",K3)-1)+0)=(MID(K3,FIND("-",K3)+1,255)+0),1,IF((LEFT(K3,FIND("-",K3)-1)+0)<(MID(K3,FIND("-",K3)+1,255)+0),0)))
but that looks messy i'm sure theres a better way

Thanks to the both of you.

But what I was wondering was how do I add the ""'s to the formula, so when nothing is entered into the cell, it makes their be no points added, so it leaves the cell blank?

Thanks a lot.
Pupil.

Originally Posted by martindwilson

then string it all together like this
=IF((LEFT(K3,FIND("-",K3)-1)+0)>(MID(K3,FIND("-",K3)+1,255)+0),3,IF((LEFT(K3,FIND("-",K3)-1)+0)=(MID(K3,FIND("-",K3)+1,255)+0),1,IF((LEFT(K3,FIND("-",K3)-1)+0)<(MID(K3,FIND("-",K3)+1,255)+0),0)))
but that looks messy i'm sure theres a better way

Thanks very much, it works.

How do I reverse this formula though so it works for away games, I've tried changing all the "LEFTS" into "RIGHTS" that doesn't seem to work.

Sorry for being such a burden.

Thanks a lot.

Pupil