Is there a regional settings issue in this formula?

[valmir]

The formula in column O is not behaving the way it is supposed to. Can someone please check and be able to tell me why it is not working for me? The formula is supposed to sum the whole part and the decimal part of the number separately and then present the result separated by a comma. Somehow, when I try it, it is not showing the decimal parts of the sum. Please help!

ztest3.xlsx
	G	H	I	J	K	L	M	N	O
1	7,12		5,2		2,1		0,1		14,0
2	7,12		5,2		2,1		0,1		14,0
3			5						5,0
4									0,0
5							0,1		0,0
Sheet1

Cell Formulas
Range	Formula
O1:O5	O1	=(TRUNC(G1,0)+TRUNC(I1,0)+TRUNC(K1,0)+TRUNC(M1,0))&","&IFERROR(VALUE(MID(G1-TRUNC(G1,0),FIND(".",G1-TRUNC(G1,0))+1,256)),0)+IFERROR(VALUE(MID(I1-TRUNC(I1,0),FIND(".",I1-TRUNC(I1,0))+1,256)),0)+IFERROR(VALUE(MID(K1-TRUNC(K1,0),FIND(".",K1-TRUNC(K1,0))+1,256)),0)+IFERROR(VALUE(MID(M1-TRUNC(M1),FIND(".",M1-TRUNC(M1))+1,256)),0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G1:N2,O1:P5	Cell Value	=0	text	NO

This is what I'm getting:

 

[valmir]

=LET(a;INDEX(G1:M1;1;{1;3;5;7});VALUE(SUM(INT(a))&","&SUM(IFERROR(--MID(a;FIND(",";a)+1;5);0))))

Tested and working 100% Now it's perfect! Thank you so much for your help Sir!