Can you roundup in excel

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More…Less

This article describes the formula syntax and usage of the ROUNDUP function in Microsoft Excel.

Description

Rounds a number up, away from 0 (zero).

Syntax

ROUNDUP(number, num_digits)

The ROUNDUP function syntax has the following arguments:

  • Number    Required. Any real number that you want rounded up.

  • Num_digits    Required. The number of digits to which you want to round number.

Remarks

  • ROUNDUP behaves like ROUND, except that it always rounds a number up.

  • If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.

  • If num_digits is 0, then number is rounded up to the nearest integer.

  • If num_digits is less than 0, then number is rounded up to the left of the decimal point.

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Formula

Description (Result)

Result

=ROUNDUP(3.2,0)

Rounds 3.2 up to zero decimal places.

4

=ROUNDUP(76.9,0)

Rounds 76.9 up to zero decimal places.

77

=ROUNDUP(3.14159, 3)

Rounds 3.14159 up to three decimal places.

3.142

=ROUNDUP(-3.14159, 1)

Rounds -3.14159 up to one decimal place.

-3.2

=ROUNDUP(31415.92654, -2)

Rounds 31415.92654 up to 2 decimal places to the left of the decimal point.

31500

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Источник

Purpose 

Round a number up to a given number of digits

Usage notes 

The ROUNDUP function rounds numbers up. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDUP rounds all numbers up. For example:

=ROUNDUP(3.1,0) // returns 4

ROUNDUP takes two arguments, number and num_digits. Number is the number to be rounded, and num_digits is the place at which number should be rounded. When num_digits is greater than zero, the ROUNDUP function rounds on the right side of the decimal point. When num_digits is less or equal to zero, the ROUNDUP function rounds on the left side of the decimal point. Use zero (0) for num_digits to round to the nearest integer. The table below summarizes this behavior:

Digits Behavior
>0 Round up to nearest .1, .01, .001, etc.
<0 Round up to nearest 10, 100, 1000, etc.
=0 Round up to nearest 1

Round to right of decimal

To round up values to the right of the decimal point, use a positive number for digits:  

=ROUNDUP(A1,1) // Round up to 1 decimal place
=ROUNDUP(A1,2) // Round up to 2 decimal places
=ROUNDUP(A1,3) // Round up to 3 decimal places
=ROUNDUP(A1,4) // Round up to 4 decimal places

Round to left of decimal

To round up values to the left of the decimal point, use zero or a negative number for digits:  

=ROUNDUP(A1,0) // Round up to nearest whole number
=ROUNDUP(A1,-1) // Round up to nearest 10
=ROUNDUP(A1,-2) // Round up to nearest 100
=ROUNDUP(A1,-3) // Round up to nearest 1000
=ROUNDUP(A1,-4) // Round up to nearest 10000

Nesting inside ROUNDUP

Other operations and functions can be nested inside the ROUNDUP function. For example, to round the result of A1 divided by B1, you can use a formula like this:

=ROUNDUP(A1/B1,0) // round up result to nearest integer

Other rounding functions

Excel provides a number of rounding functions, each with a different behavior:

  • To round with standard rules, use the ROUND function.
  • To round to the nearest multiple, use the MROUND function.
  • To round down to the nearest specified place, use the ROUNDDOWN function.
  • To round down to the nearest specified multiple, use the FLOOR function.
  • To round up to the nearest specified place, use the ROUNDUP function.
  • To round up to the nearest specified multiple, use the CEILING function.
  • To round down and return an integer only, use the INT function.
  • To truncate decimal places, use the TRUNC function.
Источник

What is ROUNDUP Excel?

The ROUNDUP excel function calculates the rounded value of the number to the upward side or the higher side. In other words, it rounds the number away from zero. Being an inbuilt function of Excel, it accepts two arguments–the “number” and the “num_of _digits.” For example, “=ROUNDUP(0.40,1)” returns 0.4.

Syntax

The syntax of the roundup excel formula is stated as follows:

ROUNDUP Formula

The function accepts the following mandatory arguments:

  • Number: This defines the floating-point number, which is to be rounded up.
  • Num_of_digits: This defines the number of digits to which the number is to be rounded. It can be positive, negative or zero.

Note: Both the arguments of the ROUNDUP function must be integers.

The Values of “Num_of_Digits”

The “num_of_digits” argument can take the following values:

  • If “num_of_digits” is greater than 0, the number is rounded up to the defined number of decimal places.
  • If “num_of_digits” is equal to 0, the number is rounded up to the nearest integer.
  • If “num_of_digits” is less than 0, the number is rounded up to the nearest 10, 100, 1000, and so on. All the decimal places are removed.

Note: The “num_of_digits” can take values from 1 to 9 only.

Table of contents
  • What is ROUNDUP Excel?
    • Syntax
    • How to Use the ROUNDUP Function in Excel?
      • Example #1
      • Example #2
      • Example #3
    • Frequently Asked Questions
    • Recommended Articles

How to Use the ROUNDUP Function in Excel?

You can download this ROUNDUP Function Excel Template here – ROUNDUP Function Excel Template

The ROUNDUP function works similar to the ROUND functionROUND is a built-in Excel function that calculates the round number of a given number using the number of digits as an argument. The number to be rounded up to and the number of digits to be rounded up to are the two arguments to this formula.read more, except that the former rounds the number upwards. Let us consider a few examples to understand the working of the ROUNDUP formula.

Example #1

Let us calculate the output with positive values of “num_of_digits.” This implies that the “num_of_digits” is greater than zero.

Example #2

Let us calculate the output with “num_of_digits” equal to zero.

Example #3

Let us calculate the output with negative values of “num_of_digits.” This implies that the “num_of_digits” is less than zero.

Frequently Asked Questions

1. Define the Excel ROUNDUP function.

The ROUNDUP function helps round a number to the higher side. Being a Math and Trigonometry function, it returns an approximate value, thereby making the numbers simpler to understand.

The ROUNDUP function is used in situations where an estimate is required. As calculations become easy, reporting numerical values is no longer a complicated task. The ROUNDUP function accepts two mandatory arguments–the “number” and the “num_of _digits.”

2. How does Excel round up to the nearest whole number?

For rounding up to the nearest whole number, the “num_of _digits” in the ROUNDUP formula is specified as zero. The formula is stated as follows:

“=ROUNDUP(number,0)”

For example, “=ROUNDUP(74.26,0)” returns 75.

3. How to round a number up and down in Excel?

Recommended Articles

This has been a guide to the ROUNDUP function of Excel. We have gone through the ROUNDUP formula in Excel, the usage, and the examples. The Excel templates can be downloaded from the site. You may also look at these useful functions in Excel –

  • VBA RoundUp
  • MROUND in Excel
  • Mixed References in Excel

Reader Interactions

Источник

In this tutorial, we will learn to round numbers in multiple ways in Microsoft Excel. We can round numbers either via the Home tab or by using different formulas like the ROUND, ROUNDUP, and ROUNDDOWN functions in Excel.

Also read: How to Stop Excel from Rounding?

To directly round numbers without using a formula, here’s what you can do.

decimal num1
A Decimal Number
  • Type a decimal number in a cell with more than 2 or 3 digits after the decimal point.
  • Go to the Home tab.
  • Under the Number section, select the Increase Decimal or Decrease Decimal icon to round up that number.
increase decrease decimal
Increase or Decrease Decimal

You can see that the number has been rounded up after selecting the Decrease Decimal option in Excel.

decreased decimal
Decimal Decreased

Using the ROUND function in Excel

The ROUND function is created to round numbers in Excel. Let’s see how we can round numbers with this function.

decimal num1
A decimal Number
  • Type a decimal number in a cell.
  • Type =ROUND( in another blank cell.
  • Select the decimal number.
  • Put a comma and type the number of digits you want to have after the decimal point.
  • Close brackets and press ENTER.
round
Using the ROUND Function
round calculated
ROUND Function Used

You can see that the ROUND formula has rounded up the number in the cell. Let us try another example by putting 0 digits to be shown.

round 0 digit
0 Digits to Show

You can see that the ROUND function has rounded up the two numbers into whole numbers.

Note – Any decimal number that has a number equal to or greater than 0.5 after decimals, then that number gets rounded up to the nearest highest whole number if 0 digits have been applied in the ROUND function.

Using the ROUNDUP function in Excel

The ROUNDUP function is used to round up decimal numbers to the nearest highest decimal point in Excel. Let’s see how we can round up numbers with this function.

2 numbers
Two Decimal Numbers
  • Type a decimal number in a cell.
  • Type =ROUNDUP( in another blank cell.
  • Select the decimal number.
  • Put a comma and type the number of digits you want to have after the decimal point.
  • Close brackets and press ENTER.
roundup 2 digits
Using the ROUNDUP Function
roundup
Rounded Up Both Numbers

We can see that the two numbers have been rounded up by the ROUNDUP function in Excel to the nearest highest decimal point.

Let’s now see what results do we get after applying 0 digits to be seen after the decimal point

roundup 0 digits
Rounding With 0 Digits After Decimal Point

You can see that both numbers irrespective of any number after the decimal point, get rounded up to the nearest highest whole number by the ROUNDUP function.

You can clearly figure out the difference between the ROUND and the ROUNDUP function when it comes to applying 0 digits in the num_digits argument. The ROUND function will not round up to the nearest whole number until any number equal to greater than 0.5 is entered after the decimal point.

Using the ROUNDDOWN function in Excel

The ROUNDDOWN function, as the name suggests, is contrary to the ROUNDUP function in Excel. It is used to round down decimal numbers to the nearest lowest decimal point. Let’s see how we can round down numbers with this function.

2 numbers 1
Two Decimal Numbers
  • Type a decimal number in a cell.
  • Type =ROUNDDOWN( in another blank cell.
  • Select the decimal number.
  • Put a comma and type the number of digits you want to have after the decimal point.
  • Close brackets and press ENTER.
rounddown
Using the ROUNDDOWN Function
rounddown 2 digits
Rounded Down Both Numbers

You can see that the ROUNDDOWN function has rounded down the two numbers in Excel. There is little to no difference in the numbers except that there are only 2 digits to be seen after the decimal point now.

Let’s see the result after putting 0 digits in the num_digits argument.

rounddown 0 digits
Applying 0 Digits After Decimal

You can see that both numbers have been rounded down to the nearest lowest whole number regardless of the number being greater or less than 0.5 after the decimal point.

Conclusion

This was all about the round functions in Excel and a step-by-step guide on using and applying them. Feel free to comment your doubts below regarding rounding numbers in Excel, if you have any! Stay tuned for more informative tutorials like this!

References: Microsoft

Источник

totn Excel Functions

This Excel tutorial explains how to use the Excel ROUNDUP function with syntax and examples.

Description

The Microsoft Excel ROUNDUP function returns a number rounded up to a specified number of digits. (Rounds away from 0.)

The ROUNDUP function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ROUNDUP function can be entered as part of a formula in a cell of a worksheet.

Syntax

The syntax for the ROUNDUP function in Microsoft Excel is:

ROUNDUP( number, digits )

Parameters or Arguments

number
The number to round up.
digits
The number of digits to round the number up to.

Returns

The ROUNDUP function returns a numeric value.

Applies To

  • Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

  • Worksheet function (WS)

Example (as Worksheet Function)

Let’s look at some Excel ROUNDUP function examples and explore how to use the ROUNDUP function as a worksheet function in Microsoft Excel:

Microsoft Excel

Based on the Excel spreadsheet above, the following ROUNDUP examples would return:

=ROUNDUP(A1, 0)
Result: 663

=ROUNDUP(A1, 1)
Result: 662.8

=ROUNDUP(A2, -1)
Result: 60

=ROUNDUP(55.1, -1)
Result: 60

=ROUNDUP(-23.62, 1)
Result: -23.7
Источник

Понравилась статья? Поделить с друзьями:

А вот еще интересные статьи:

  • Can you round in excel
  • Can you rhyme the word orange
  • Can you rhyme the same word
  • Can you rhyme a word with orange
  • Can you reverse words in word

    • 0 0 голоса
    Рейтинг статьи
    Подписаться
    Уведомить о
    guest

    0 комментариев
    Старые
    Новые Популярные
    Межтекстовые Отзывы
    Посмотреть все комментарии