ExcelBanter - round up numbers to next highest "4"

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - round up numbers to next highest "4" (https://www.excelbanter.com/excel-worksheet-functions/59885-round-up-numbers-next-highest-4-a.html)

Jaisenm

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?

Ron Coderre

round up numbers to next highest "4"

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?

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