hello i have a range of column in a spreadsheet (from A1 to A30) filled with decimal numbers. Now i want to get the sum only of the decimal part. For example :
if i have this numbers :
then the sum of the decimals should be : 1.5
Any idea how i could do this ?
Also do the same with the integer part of them
I have tried =SUM(MOD(A1;1):MOD(A6;1)) but no result
Thanks in advance