View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jbagger Jbagger is offline
external usenet poster
 
Posts: 2
Default Rounding errors when a "5" is the third decimal place using formul

I am having rounding errors in Excel. When I use a formula to make a
calculation, the resulting numbers will not round correctly when a 5 is the
third decimal place. Iit always rounds down, instead of up. I can enter the
same number in another cell with no formula and it rounds correctly. This
results in very inconsistent calculations. Any ideas or fixes? Thank you!