why are my columns not adding correctly

[Guest]

I am new to excel, and am using a spreadsheet alreadey set up, when I have
two cells to add up, the total is off by 1 penny, why? Formula says
=Sum(F2:G2)
help.....

 

[S S]

It could be the formatting of the cells, with some rounding up taking place.

 

[Niek Otten]

http://www.mcgimpsey.com/excel/pennyoff.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am new to excel, and am using a spreadsheet alreadey set up, when I have
| two cells to add up, the total is off by 1 penny, why? Formula says
| =Sum(F2:G2)
| help.....

 

[Guest]

Thank you, but how do I correct the rounding up?

It could be the formatting of the cells, with some rounding up taking place.

 

[Fred Smith]

Use =Round(YourFormula,2), then sum.