why are my columns not adding correctly
 

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.....

why are my columns not adding correctly
 

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

"Cathie" wrote in message
...
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.....

why are my columns not adding correctly
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Cathie" wrote in message ...
|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.....

why are my columns not adding correctly
 

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

"S S" wrote:

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

"Cathie" wrote in message
...
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.....

why are my columns not adding correctly
 

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

--
Regards,
Fred


"Cathie" wrote in message
...
Thank you, but how do I correct the rounding up?

"S S" wrote:

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

"Cathie" wrote in message
...
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.....