View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default 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.....