Posted to microsoft.public.excel.worksheet.functions

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Help with rounding formulas

On Tue, 5 Sep 2006 21:16:17 +0100, TriciaF
wrote:

I am trying to round a whole number to the nearest hundred ex 8490 needs
to be rounded to 8500. How do I do this?

=ROUND(A1,-2)

--ron

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
How to Evaluate Dynamic DDE Formulas	MArcus Baffa	Excel Worksheet Functions	5	September 12th 06 10:35 PM
how to minimize rounding error with complicated formulas	Erick T.	Excel Discussion (Misc queries)	1	January 25th 06 02:05 PM
formulas / rounding	JT	Excel Worksheet Functions	3	January 19th 06 10:49 PM
rounding a formula's number	[email protected]	Excel Worksheet Functions	2	March 9th 05 07:33 PM
calculating formulas for all workbooks in a folder	Chad	Excel Worksheet Functions	3	November 13th 04 05:22 PM

All times are GMT +1. The time now is 02:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us