numbers add rounding to sum formula

HI I am summing cells and they need to always be rounded to .00 how do i add rounding to the sum function to do that
Thanks

latest osx iMac 27

Lookup the "round" function in addition to the "sum" function you are using to get what you want.

thx
but i am not finding anything that could help me add rounding to something like this =sum(a10+d10) maybe i word m search wrong but the only answer i came up with was for excel

I don't have Numbers installed locally, so I'm doing this with Numbers on iCloud, but it should work the same.

There are the functions ROUND, ROUNDUP and ROUNDDOWN.

So if you have the following values:
A1: 1.36
B1: 1.21

In C1, if you do =SUM(A1,B1), you'll get the result 2.57

With the three round functions in D1, E1 and F1, you'll get:


The 0 indicates no decimal places, if you put a 1 in there, you get:


Play around with this until you get what you want. You can also try round before summing or the other way depending on what you want.

@ RazorEdge
Thx
Well it worked in most cases. but where i summed a column =sum(a15) i couldn't get it to work . most likely user error.
jmickeyg

Are you having issues with the ROUND functions or SUM? As long as the values in cells A1 through A5 are numbers, the SUM function should handle that no problem.

The problem is the round , all cells in column have valid numbers. which are sums from other cells in there rows
that may be the problem ? numbers in cells included in sum i am trying to round are all formulae of the a1+a2+a3 type

jmickeyg

Can you tell us some example of what the sums look like? Also, are you getting any errors?

thanks for your help this last one was definitely user error. I got it to work . you gave all the correct info i was just missing something as i typed. thx

Sweet. Be sure to tip your waiter on your way out.