Thread: formula that sums cells yet does not round the number up or down.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default formula that sums cells yet does not round the number up or down.
Sounds like each cell in M9:M11 should be rounded as they contain fractions
of a penny. Then the total will come out correctly...
--
HTH...

Jim Thomlinson


"cioangel" wrote:

I am trying to sum up 3 cells of 2,140.22. (Net pay)
Yet my =sum(M9:M11) delivers the number 6,420.67. That is an incorrect
amount for my payroll records. ??
Reply With QuoteReply With Quote