On Wed, 26 Oct 2005 11:36:03 -0700, "FA" wrote:

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

Wouldn't you always want to round up?

If so, you could use =CEILING(num,48)


--ron