Posted to microsoft.public.excel.worksheet.functions

Mal

Posts: n/a

Rounding Up or down to 1/2 Units

Hi People,
Is there a way to round up or down in 1/2 units.
e.g. 2.3 up to 2.5, 2.1 down to 2.
Any help appreciated.
Thanks,
Mal

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
Percentage rounding error in charts	Tracey	Excel Discussion (Misc queries)	4	May 14th 05 04:01 AM
Changing Secondary axis value units	sherobot	Charts and Charting in Excel	4	May 2nd 05 07:00 PM
Page margin units	Alberto	Excel Worksheet Functions	2	April 2nd 05 12:23 AM
Banker's Rounding - need help!	Somecallmejosh	Excel Discussion (Misc queries)	3	January 20th 05 09:53 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another	John Smith	Charts and Charting in Excel	7	December 21st 04 08:26 PM

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

About Us

"It's about Microsoft Excel"