Quote:
Originally Posted by tomcat82
12.2 is still 12.2, but 12.3 should be 13.0
Basically .3 should already be the next .0. You know what I mean?
12.3 - 13.0
15.3 - 16.0
etc.
e.g.
15.2 + 0.1 = 16.0
15.2 + 0.2 = 16.1
|
Sorry, I will get my head around this eventually.
I think maybe a running score is needed. It could be hidden so you only get the latest score, but to save writing a very long nested formula to give the result you need I think that's the best approach.
So, taking your example earlier, what would be the desired results after each game?
Game 1: 6.1 = ?
Game 2: 5.2 = ?
Game 3: 4.2 = ?
Game 4: 5.2 = ?