Hi!

So, what you want to do is round to the nearest multiple of 48?

=ROUND(A1/48,0)*48

Biff

"FA" wrote in message
...
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