Excel Problem

[Niall 84]

Bit of a strange one this, and probably quite an easy one that i'm
completly missing!!!

Basically I was to try and make a form of a league table based on the
results of different Gaelic football matches. The problem is that the
scoring in gaelic football is slightly different to normal.....1 goal
= 3 points so therefore a score of 1-8 would = 0-11 (thats goals-
points)


Is there anyway of formatting cells so they will multiply parts of a
cell by 3 and just add it to the rest of the cell?

Please let me know if there is any suggestions.

Thanks,

Niall.

 

[Bernard Liengme]

Best plan: use two columns - one for the home team, one for the away (or is
it the other way?)
You can always connactiante then for printing purposes as in =A1& "-" &B1
best wishes

 

[Billy Liddel]

Bit of a strange one this, and probably quite an easy one that i'm
completly missing!!!

Basically I was to try and make a form of a league table based on the
results of different Gaelic football matches. The problem is that the
scoring in gaelic football is slightly different to normal.....1 goal
= 3 points so therefore a score of 1-8 would = 0-11 (thats goals-
points)


Is there anyway of formatting cells so they will multiply parts of a
cell by 3 and just add it to the rest of the cell?

Niall.

You will have to use formulas. Score column must be formatted as text before
entering the score

County Score Points
Wexford 1-8 11

formula in C2 is:

=LEFT(B2,FIND("-",B2)-1)*3+RIGHT(B2,LEN(B2)-FIND("-",B2))*1

Use columns D:F for the other team

Peter

 

[Niall 84]

That is brilliant,

Thanks a million for your help,

Niall.

(Wexford scoring 1-8? I'm not really buying that one!!!)