Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) |