Posted to microsoft.public.excel.worksheet.functions

LarryUSCGMWR LarryUSCGMWR is offline

external usenet poster

Posts: 2

Help with formula to round up to next higher multiple of 5

Hi,

I am looking for a quick formula that can take a number and round it up to
the next higher integer that is a multiple of 5. Does anyone have a formula
for this. You can email me at with any suggestions.

Thanks

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
what is the formula in excel for higher level of square roots	Cindy Nguyen	Excel Discussion (Misc queries)	4	March 26th 08 11:40 PM
Round to multiple of 5	JmyCrikitt	Excel Worksheet Functions	3	February 28th 08 08:50 PM
Why does Excel INT(x) behave like ROUND(x,0) for 10^14 and higher?	joeu2004	Excel Discussion (Misc queries)	4	January 18th 08 08:42 PM
Replacing formula with round multiple times	andyhofer	Excel Discussion (Misc queries)	1	January 17th 08 09:42 PM
multiple and round	Heather Gilroy	Excel Worksheet Functions	2	July 22nd 05 06:38 PM

All times are GMT +1. The time now is 08:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us