Excel Problem

  • Thread starter Thread starter Niall 84
  • Start date Start date
N

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.
 
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
 
Niall 84 said:
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?
Click to expand...

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
 
That is brilliant,

Thanks a million for your help,

Niall.

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