Thread: Rounding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BarbHerb BarbHerb is offline
external usenet poster
 
Posts: 1
Default Rounding

Why does Excel round correctly sometimes but not all the time when using the
"decrease decimal" function?

Take for example the number - 6.464640
When you decrease the last digit you get - 6.46464
Excel rounds correctly, 0 is less than or equal to 5 so the 4 stays as is

When you decrease the next digit - 6.4646
Excel rounds correctly, 4 is less than or equal to 5 so the 6 stays as is

When you decrease the next digit - 6.465
Excel rounds correctly, 6 is greater than or equal to 5 so the 4 rounds to 5

When you decrease the next digit - 6.46
Excel does not round correctly, 5 is greater than or equal to 5 so the 6
should round to 7 but does not

Why is that please? Thanks! Barb