Thread: Rounding to the odd
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lonnie[_2_] Lonnie[_2_] is offline
external usenet poster
  
Posts: 1
Default Rounding to the odd
In meteorology it is the custom to round decimal numbers ending in .5 to the odd. For instance 2.55 becomes 2.3, while 2.35 also becomes 2.3. In Excel they are always rounded up, does anyone know a formulae that will correct this so that they are 'thrown' to the odd.
TIA
Lonnie


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

Reply With QuoteReply With Quote