LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
FA
 
Posts: n/a
Default Rounding for order size

I'm doing a forecast using some formulas.
I want the result to take in consideration the minimun order size.

For example if my forecast is 38 I want the result to be expressed as 48
which is the minimun package size.

The same for example if forecast is 500 I want it to show 480 or 528 which
are the actual amounts that I can request.

How can I do this?

FA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Font size in conditinal formatting GDC Excel Discussion (Misc queries) 0 October 18th 05 06:38 PM
Font size prints same size regardless of how I set it in Excel Marcusmouse Excel Discussion (Misc queries) 2 May 26th 05 03:25 PM
Large Excel file size caused by a bug ? I really tried everything Anik Excel Discussion (Misc queries) 5 March 16th 05 06:19 PM
Customize page size puzzled Setting up and Configuration of Excel 0 February 18th 05 05:41 AM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM


All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"