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