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

D21: =ROUND(SUM(D1:D20),0)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"nikicole134" wrote in message
...
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

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

Hi nikicole,

If you have a number that is not a whole number but you want it to show
as a whole number Excel has to apply a logical way of doing this which
is rounding up or down so it knows what to do

When you format the cell to no decimal places it does not get rid of
the decimal places - it displays the number rounded but the value is
still maintained so if you use it subsequently it uses the real
number.

If you want the number to be a whole number use the ROUND function,
that gets rid of extra decimal place but will still round up or down.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=517784

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

Replace your =SUM(D1:D20) formula with this.....

=INT(SUM(D1:D20))

Vaya con Dios,
Chuck, CABGx3



"nikicole134" wrote:

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