Round up to the nearest divisible quantity

  • Thread starter Thread starter bjl
  • Start date Start date
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
 
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...
 
You must log in or register to reply here.

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 up to the nearest 1000 1
Giveaway The Division FREE 2
Rounding to nearest 250 by 125s 3
SUM - IF - AND 7
Rounding Time to Nearest 5 Minutes 1
Median with Quantity Column 3
Rounding Time. 4
Sums divisible by 12 2

Back
Top