Round up to the nearest divisible quantity

B

bjl

Is there a formula or statement that will check to see if a quantity i
evenly divisible by a certain # and if not the result would be rounde
up to the next increment.

Example: I need to buy 75 items but they need to be purchased i
quantities of 8.

The result of the formula should be 80.

Thanks for the help.
Barbar
 
C

CLR

My bad...........Frank and JE were correct of course..........

should be =CEILING(F1,8)

sorry
Vaya con Dios,
Chuck, CABGx3


CLR said:
=CEILING(F1,10)

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
rounding up to the nearest 1000 1
Rounding Time. 7
Function help 7
Conditional Multiply and Sum 2
Rounding numbers up or down in same formula 6
Round Function 5
to calculate numbers upwards to the nearest 300 and then to group 4

Top