View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default formula that sums cells yet does not round the number up or down.

=sumproduct(round(M9:M11,2))

the amounts aren't exactly .22, there is more which rounds to an extra .01

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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