Rounding Up
 

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.

Rounding Up
 

Try this:

=CEILING(A1/8,1)

--

HTH,

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

"Frustrated" wrote in message
...
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.

Rounding Up
 

=ROUNDUP(A1/8,0)
--
David Biddulph

"Frustrated" wrote in message
...
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.