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