Posted to microsoft.public.excel.worksheet.functions

Vin C.

Posts: n/a

Rounding up results to meet minimum order quantities.

There was a formula I used in the past that would bump up the results in a
cell to the next highest group of ten. For example, if the results were "16"
the formula would return "20". If the results were "32" the formula returns
"40" and so on. I would like to use this function again but can't remember
the formula. Any assistance will be appreciated. Thanks! Vince

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
abdualmohsn	almedrahe abdualmohsn ahmad	Excel Discussion (Misc queries)	1	November 19th 05 06:32 PM
Rounding results to nearest quarter (in decimals)	djarcadian	Excel Discussion (Misc queries)	5	October 27th 05 12:35 AM
Rounding for order size	FA	Excel Discussion (Misc queries)	3	October 26th 05 09:08 PM
6th order polynomial equ yields unexpected results	Sanjay Kumar Limbikai	Charts and Charting in Excel	11	September 27th 05 12:36 AM

All times are GMT +1. The time now is 08:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us