Thread: ROUNDING
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EDB EDB is offline
external usenet poster
 
Posts: 1
Default ROUNDING

I have a formula e62/c62 - the answer is formatted for %. It is 49.48% when
carried out 2 dec. When carried out 1 is rounds to 49.5%, BUT when I have no
dec. it won't round to 50% - it stays at 49%. I can make it round to 50%,
but how come just formatting it doesn't carry through the standard rounding
up. - Thanks