Formatting help

[KasperSSI]

Hi,

I have this problem with my excel in general:

above sum should be 0. All decimals are exactly 2. Is there something i can correct in the formatting in my excel?

Thank you in advance for your help.

 

[Joe4]

It looks like you may have the floating arithemetic situation going on there (returning a miniscule decimal).
Simply use the ROUND function to return 2 decimal places, i.e.
=ROUND(SUM(...),2)

See here for a complete explanation: Floating-point arithmetic may give inaccurate result in Excel - Office