answersLogoWhite

0

To round up a number to the next highest whole number of a certain multiple use the CEILING function. Use the built in function ROUND for general rounding to the nearest value. It can round down or round up. There is a function called ROUNDUP which always rounds up.

The CEILING function takes two arguments, the first is the number to be rounded up, the second is whole number multiple to round up to. For example: CEILING(1.2345,1) gives 2 but CEILING(1.2345,5) gives 5

To round the contents of cell A1 to the next highest whole 10 and put the result in cell B2 you would: Click on cell B2 Type =CEILING(A1,10) Click on cell A1 Type 14.65 And cell B2 will show the result 20 which is 14.65 rounded to the next highest whole multiple of 10.

CEILING will not handle negatives numbers and will return a #NUM! error if you try.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

How many functions can be nested with the same formula in MS Excel?

Excel 2003 = 8 levels of nesting Excel 2007 = 64 levels of nesting


What is round up formula?

copy paste formula results without pasting the formula


What is round up?

copy paste formula results without pasting the formula


How do you use Microsoft Excel roundup?

RoundUp function returns a number rounded up to a specified number of digits. (Rounds away from 0.)Syntax: RoundUp( number, digits )number = number to round updigits = number of digits to round the number up to


What is 5.215 rounded to the nearest hundredth?

5.22


What is vlook up?

Vlook up is the formula in microsoft excel to search the list of items vertically to find out specific information.


Why is value coming up in excel?

The #Value! error comes up when you try to use an inappropriate value in a formula. It will depend on what exactly you are doing as to why it is particularly coming up. You need to know the function you are using, what it requires and what values you are using in it.


How many decimal digits can be used with the fixed or currency format?

In Excel, up to 30. In Excel, up to 30. In Excel, up to 30. In Excel, up to 30.


When the function argument is automatically entered by excel the argument is?

When a function argument is automatically entered by Excel, it typically refers to the use of the AutoFill feature or the formula suggestion pop-up that appears as you type a function. Excel may suggest arguments based on the context of the formula or the data in the surrounding cells. Additionally, if a function requires multiple arguments, Excel may highlight the necessary cells or provide hints to guide the user in inputting the correct values. This feature enhances user efficiency by reducing the need for manual entry.


Where is hierarchy in Excel?

In Excel there can be many hierarchies. Cells are in a worksheet, a worksheet is in a workbook. A grand total formula could be adding up the results formulas giving other totals. There can be hierarchy in graphics.


Which excel formula will compute the midpoint value in a range?

Median( number1, number2, ... number_n )You may enter up to 30 values


Does every formula in Excel start with an equal sign?

Yes, in Excel, every formula must start with an equal sign (=) to indicate to the program that it is a formula and not a regular text entry. This is a key rule in Excel syntax that helps differentiate between data and calculations. Omitting the equal sign will result in Excel treating the entry as text rather than a formula.