Posted to microsoft.public.excel.misc

joeb

external usenet poster

Posts: 11

Round to the nearest 9 cents

Simple - I need to retail round 12.03 to 11.99 and 12.05 to 12.09.

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
Rounding to the nearest 50 cents	Jerid B	Excel Discussion (Misc queries)	4	February 8th 07 05:43 PM
Currency Rounding to nearest 5 cents	Daniel Sloan	Excel Discussion (Misc queries)	3	July 20th 06 08:42 AM
Rounding to nearest 5 cents in excel	usnst	Excel Worksheet Functions	3	January 17th 06 12:27 AM
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS	PRICEMGR	Excel Worksheet Functions	5	November 22nd 05 03:32 PM
I am trying to round up to the nearest 25 cents	sypher	New Users to Excel	2	April 26th 05 01:14 AM

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

About Us

"It's about Microsoft Excel"