summing fractions return wrong value [closed]
I have noticed this strange behaviour in the =sum() function in calc.
D1 contains the =sum(a1:c1) formula, as indicated in the screenshot.
Is sum only adding integer values and ignore float values?
Any suggestions on how this can be rectified?
Format D1!
Format it to 6.0? The summed answer should be 8.5, so the fact that I did not format it correctly doesn't change a thing.
Some issues vanish next to immediately if their cause gets obvious.
Therefore: Avoid explicit horizontal alignment for cells wherever possible (which means next to always).
The horizontal 'Default' alignment works by displaying texts left aligned and numbers right aligned. Using this clever setting you will never again puzzle about why something looking like a number isn't processed as one.
If you want to have some distance between cell grid lines and cell contents you can use the 'Padding' (left, right) settings under 'Borders' for your formatting.