Rounding Up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like an answer to a formula to always round up to a whole number.

I am an educator and the student's problem involves pizza orders.
The pizzas are always divided into 8 slices. The students tally a students'
orders by slices and enter it into the spreadsheet. Their formula will
divide and display how many pizzas they should order. Thus the reason for
rounding up.
 
Try this:

=CEILING(A1/8,1)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I would like an answer to a formula to always round up to a whole number.

I am an educator and the student's problem involves pizza orders.
The pizzas are always divided into 8 slices. The students tally a students'
orders by slices and enter it into the spreadsheet. Their formula will
divide and display how many pizzas they should order. Thus the reason for
rounding up.
 
Back
Top