I tried that and it didnt work the result was 0?
here are some examples...the formula I am using is D=B/C,
column D results are 52.93, 1,412.83, 4,028.89, 1,189.20, 34.74
I need a formula to have the sum of column D to not round
(6,718.59) I need the total to be 6,718 not rounded up to 6,719.


"CLR" wrote:

If the results of a formula are say 7.625, then that is the number.....to get
a "whole number" it MUST be "rounded" either up or down to produce either 8
or 7 respectively......if you want only the 7, you could use
=INT(SUM(D1:D20)), or =INT(YourFormula), but this is in effect "rounded
down"...........if this don't do it for you, please provide some actual
results, and the desired results......

Vaya con Dios,
Chuck, CABGx3



"nikicole134" wrote:

I am trying to find a way to stop excel from rounding calculated numbers. Let
me try to explain....
example of the worksheet
Step 1: column D formula is B15/C16 (I need a whole number, but when I put
decimal places at 0 it rounds)
Step 2: D21=sum of D1:D20
I need the sum of D21 to be a whole number neither rounded up or down