The formula in question is:
=D30-(E11+E23)*D30/100
I checked the D column and E column and both are set with the formatting as
Number.

"bj" wrote:

can you give an example of what you are doing and show the problem?
if the input data is 6 digits and the finial equatin is six digits it should
not have to round up. the the sum of what you see is not the same as what
sum() gives, then there is data past the sixth decimal place in your
incoming data, even if it shows only 6

"Janet" wrote:

Wow! Didn't expect such great responses so quickly. In the case of the
formatting, the formula is formatted as a number with 6 decimal places (it
has to be). What if part of the formula has a hard number (like 100) and not
a cell reference? Would that be apart of the problem?

"Dave Peterson" wrote:

And if your cell with the =sum() formula is formatted as general, maybe you're
only seeing 2 decimal places.

Try widening that column or change to a smaller font.

Janet wrote:

I am using SUM to add up a column with numbers that have six decimals. I do
not want the answer to be rounded up. How can I create a formula not to round
the answer, using SUM? Thanks

--

Dave Peterson