View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jaisenm
 
Posts: n/a
Default round up numbers to next highest "4"

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?