Score conversion trailing zero issue

[tigerzen]

Got a simple formula to convert goals and behinds into points, each goal is worth 6 points and a behind is worth 1 point. Formula works in all cases except when you have something like 17.10, this should calculate to 17 x 6 + 10 x 1 which equals 112 points. As you can see in the file, it drops the 0 from 17.10 and calculates 103. I've tried Custom formats but no joy here. Is there a way to force TEXTAFTER to recognise the 0 or is there another quick solution?

Book3
	A	B	C	D	E	F	G	H	I	J	K
1	Scores					Points
2	3.2	4.5	6.7	9.8		20	29	43	62
3	7.1	9.5	13.8	17.10		43	59	86	103		1
Sheet1

Cell Formulas
Range	Formula
F2:I3	F2	=INT(A2)*6+(TEXTAFTER(A2,"."))
K3	K3	=TEXTAFTER(D3,".")

 

[Alex Blakenburg]

Yes, this works well.

Thanks for letting us know. Glad we could help.