View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pauline
 
Posts: n/a
Default Rounding Issuewith .5

I already have a formula in a cell that is formatted to a percentage with no
decimal places. The problem I have is that excel decides to either round up
or down the result if it ends with .5 How can I ensure that the final result
is rounded up to the next full number if if currently ends with .5

For example 7.1 + 8.6 = 16 if no decimal points.
But 7.1 + 8.4 can either = 15 or 16 (no decimal places). How can I ensure
that this always shows 16 as 15.5 should be rounded up to 16 not down.