Cara Membulatkan Angka di Excel

>Hello Sohib EditorOnline! Do you struggle with finding the right formula to round up or down numbers in Excel? In this article, we will guide you through the steps of rounding numbers in Excel, from simple rounding to more complex formulas. Let’s get started!

1. Rounding Numbers to the Nearest Whole Number

Rounding up or down a number to the nearest whole number is the most basic type of rounding. To do this in Excel, follow these steps:

Step	Instructions
1	Select the cell or range of cells that you want to round.
2	In the formula bar, type =ROUND(number,0)
3	Press Enter

The number in the selected cell(s) will now be rounded up or down to the nearest whole number.

There is also a shortcut for rounding numbers in Excel. To round a number to the nearest whole number, use the ROUND function with one argument:

=ROUND(number)

For example:

=ROUND(9.6)

This formula will return the value 10.

Another way to round a number to the nearest whole number is by using the INT function. The INT function rounds down to the nearest integer. To round up, use the INT function in conjunction with the CEILING function:

=CEILING(number,1)

For example:

=CEILING(9.25,1)

This formula will return the value 10.

2. Rounding Numbers to a Specific Decimal Place

When you need more precision than just rounding to the nearest whole number, you can round to a specific decimal place. To do this in Excel, follow these steps:

Step	Instructions
1	Select the cell or range of cells that you want to round.
2	In the formula bar, type =ROUND(number,decimal_places)
3	Press Enter

The number in the selected cell(s) will now be rounded up or down to the specified number of decimal places.

For example, to round the number 9.613 to two decimal places, use the following formula:

=ROUND(9.613,2)

This formula will return the value 9.61.

3. Rounding Numbers Up or Down to the Nearest Multiple

If you need to round a number up or down to the nearest multiple, you can use the MROUND function. This function rounds to the nearest multiple of a number that you specify. To use the MROUND function, follow these steps:

Step	Instructions
1	Select the cell or range of cells that you want to round.
2	In the formula bar, type =MROUND(number,multiple)
3	Press Enter

The number in the selected cell(s) will now be rounded up or down to the nearest multiple.

For example:

=MROUND(9.5,5)

This formula will round the number up to the nearest multiple of 5, returning the value 10.

4. Rounding Up or Down to the Nearest 5 or 10

Rounding numbers up or down to the nearest 5 or 10 can be useful for pricing or grading. To do this in Excel, use the ROUNDUP or ROUNDDOWN function with the appropriate multiple.

To round up to the nearest 5, use the following formula:

=ROUNDUP(number/5,0)*5

To round down to the nearest 5, use the following formula:

=ROUNDDOWN(number/5,0)*5

To round up to the nearest 10, use the following formula:

=ROUNDUP(number/10,0)*10

To round down to the nearest 10, use the following formula:

=ROUNDDOWN(number/10,0)*10

5. Rounding to the Nearest Whole Number with the IF Function

You can use the IF function to round a number to the nearest whole number. To do this, use the following formula:

=IF(MOD(number,1)>=0.5,ROUNDUP(number,0),ROUNDDOWN(number,0))

The IF function checks whether the number is greater than or equal to 0.5. If it is, the function rounds up to the nearest whole number with the ROUNDUP function. If it isn’t, the function rounds down to the nearest whole number with the ROUNDDOWN function.

FAQs

1. How do I round a number in Excel?

To round a number in Excel, use the ROUND function with the appropriate number of decimal places. Alternatively, you can use the INT function in conjunction with the CEILING or FLOOR function to round up or down to the nearest integer.

2. How do I round up to the nearest whole number?

To round up to the nearest whole number, use the ROUNDUP function. Alternatively, you can use the CEILING function in conjunction with the INT function to round up to the nearest integer.

3. How do I round down to the nearest whole number?

To round down to the nearest whole number, use the ROUNDDOWN function. Alternatively, you can use the FLOOR function in conjunction with the INT function to round down to the nearest integer.

4. How do I round to the nearest multiple?

To round to the nearest multiple, use the MROUND function. This function rounds to the nearest multiple of a number that you specify.

5. What is the IF function in Excel?

The IF function is a logical function that allows you to test whether a certain condition is met. If the condition is met, the function returns one value; if it isn’t, the function returns another value.

That’s it for our guide to rounding numbers in Excel! We hope you found this article helpful. If you have any questions, feel free to leave a comment below.

Cara Membulatkan Angka di Excel