round up numbers to next highest "4"

[Jaisenm]

I ship a product that must go out in boxes of 4. To save the warehouse
personel the trouble of calculating out the number of product they will need
to stage for the next day I would like to write a formula/macro that will
perform the following changes:

19 = 20
24 = 24
30 = 32
7 = 8
11 = 12
60 = 60
81 = 84

ect.

Any ideas?

[Ron Coderre]

Try this:
A1: (some number)
B1: =CEILING(A1,4)

Does that help?

***********
Regards,
Ron


"Jaisenm" wrote:

> I ship a product that must go out in boxes of 4. To save the warehouse
> personel the trouble of calculating out the number of product they will need
> to stage for the next day I would like to write a formula/macro that will
> perform the following changes:
>
> 19 = 20
> 24 = 24
> 30 = 32
> 7 = 8
> 11 = 12
> 60 = 60
> 81 = 84
>
> ect.
>
> Any ideas?