How do I round a number to the nearest 600 in Excel?

Posted to microsoft.public.excel.worksheet.functions

Barcelona

external usenet poster

Posts: 4

How do I round a number to the nearest 600 in Excel?

I need to round numbers to the nearest multiple of 600. For example if the
number is 15,443, I am looking for a formula that would round the number to
15,600. Is there one?

Judy Sanchez

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
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER	MEGTOM	New Users to Excel	5	October 27th 05 03:06 AM
Access Excel Linked Text and Number Issues	Scott	Excel Discussion (Misc queries)	2	October 4th 05 09:24 PM
Roundup to the nearest number that is divisible by 3	Raju Boine.	Excel Worksheet Functions	1	June 22nd 05 01:15 PM
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS	KENITOSAN	Excel Discussion (Misc queries)	4	February 19th 05 10:06 PM
How to format a number in Indian style in Excel?	Victor_alb	Excel Discussion (Misc queries)	2	December 21st 04 04:21 AM

All times are GMT +1. The time now is 12:11 PM.

Menu

About Us