General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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.
Show More
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))
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))
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.
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.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539