View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nikicole134
 
Posts: n/a
Default rounding a formula with sum

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