Thread: Rounding Up
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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.