General Betting
There is currently 1 person viewing this thread.
18 Sep 14
10:44
Joined:
Date Joined:
04 Apr 03
Need a one cell formula for adding up tennis games.
Instead of 6-1, 4-6, 6-4
the date is entered into three cells like:
6.1 4.6 6.4
Need a one cell formula that takes those numbers and come to the total (in this example, 27)
Cheers.
Instead of 6-1, 4-6, 6-4
the date is entered into three cells like:
6.1 4.6 6.4
Need a one cell formula that takes those numbers and come to the total (in this example, 27)
Cheers.
sort by:
Show
per page
Replies: 3
|
By:
That's making life hard for yourself; what does conctenating the data into 3 cells give you that entering it in six cells as 6,1,4,6,6,4 doesn't? Easy enough to stick the pair of scores for each player together if you need them in that format at any point, much more fiddly taking them apart.
But, if you really must, and your 3 'scores' are in A4, B4, C$, then: =INT(A4)+10*(A4-INT(A4))+INT(B4)+10*(B4-INT(B4))+INT(C4)+10*(C4-INT(C4)) |
|
By:
Cheers and it works. Appreciated.
I'm a 'visual' person so having 6.2 6.4 versus 6 2 6 4 works for me. The cells with the decimal are pattern coded, as well. |
|
By:
No trouble.
|