formula that sums cells yet does not round the number up or down.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cioangel - 30 Oct 2006 21:17 GMT

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 to this Message

Jim Thomlinson - 30 Oct 2006 21:30 GMT

Sounds like each cell in M9:M11 should be rounded as they contain fractions
of a penny. Then the total will come out correctly...

Signature

HTH...

Jim Thomlinson

> 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 to this Message

ChuckF - 30 Oct 2006 21:36 GMT

You might want to check the values in each of the cells M9-M11. If you
have your cells formatted to show money, you may not see in the active
cell the numbers after 2 decimal places. Click on the cell and look at
the value on your function bar...I think you'll find one or all three
to be a value of 2140.222 or higher.

> 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 to this Message

cioangel - 30 Oct 2006 21:50 GMT

Thank you both. I have rounded the values of each cell. I just learned how to
do that as well. thanks again. Your responses made my life easier. :-) !

> You might want to check the values in each of the cells M9-M11. If you
> have your cells formatted to show money, you may not see in the active
[quoted text clipped - 5 lines]
> > Yet my =sum(M9:M11) delivers the number 6,420.67. That is an incorrect
> > amount for my payroll records. ??

Reply to this Message

Bob Phillips - 30 Oct 2006 21:42 GMT

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

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

Signature

HTH

Bob Phillips

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

> 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 to this Message