round up to a pack size

[joshpark1]

I have certain items that I need the order qty to round up to the pack size our vendor sells them in. For example, my formulas in the spreadsheet I have will tell me I need to order 8 pencils and 6 erasers. I have a seperate column that lists the pack size (or minimum order) as being 10 for pencils, and 5 for erasers. I would like to create a new column that would basically round the order QTY's for both the pencils and erasers to 10 each. Does that make any sense and does anyone know of a way to accomplish this? Thanks in advance for any help!

 

[shg]

=ceiling(qty, packsize)

 

[joshpark1]

works! thank you so much!

 

[shg]

You're welcome, good luck.