Posted to microsoft.public.excel.newusers

Lonnie[_2_] Lonnie[_2_] is offline

external usenet poster

Posts: 1

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need a formula with rounding up & rounding down to the nearest .	Tony Kay	Excel Worksheet Functions	3	May 29th 07 11:13 PM
ROUNDING	Bill Ridgeway	New Users to Excel	9	April 7th 07 03:04 AM
Rounding up or down	Kevin	Excel Discussion (Misc queries)	4	January 22nd 07 12:51 PM
Rounding	Richard	Excel Worksheet Functions	1	January 18th 06 05:51 PM
rounding up after SUM	fbcmusicmark	Excel Worksheet Functions	4	January 3rd 06 09:31 PM

All times are GMT +1. The time now is 03:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us