Decimals in Excel
Microsoft Excel is widely used for calculation purposes for various applications. The calculation consists of numbers which include whole numbers, decimals, integers etc. To perform quick calculations, the numbers should be simplified. To round off the numbers and to get the accuracy of the result, Excel provides default functions. Coming to the concept of decimal, if the decimal number is large, the calculation is difficult. To reduce or round off the decimal number, Excel provides the option to reduce the decimal points.
1. How to round off the Decimal values using Excel function?
To reduce the decimal values in Excel, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Choose the decrease decimal button from the Number group in Home tab.
STEP 3: The result in the cell A1 will change where the decimal point is reduced.
In the formula bar the existing value is present 14.571. To perform multiplication calculation with the value present in A1, steps followed are,
STEP 4: Select a new cell, namely B1 and enter as 5*A1.
The multiplication result is displayed in the cell B1.
2. How to round off the decimal value using formula?
The decimal values can be rounded to user desired values like ones, tens, hundreds and thousands using the respective formula.
To round off the decimal numbers, Excel provides ROUND function for calculation. It consists of two arguments. The first argument is called cell reference or number which indicates the number that needs to be rounded. The second argument indicates the, number of digits to be rounded in the given data.
2.1 How to round three numbers from the right of the decimal point?
To round off three numbers from the right of the decimal point using formula, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Select any new cell namely B1, where the result want to display
STEP 3: Enter the formula in the cell B1 as =ROUND (A1,3)
From the above worksheet the value 590.75467 is rounded to 590.76 is called nearest value, where the three numbers right to the decimal point is rounded off.
2.2 How to round two numbers from the right of the decimal point?
To round off two numbers from the right of the decimal point using formula, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Select any new cell namely B1, where the result want to display
STEP 3: Enter the formula in the cell B1 as =ROUND (A1, 2)
From the above worksheet the value 100.6789 is rounded to 100.68is called nearest value, where the two numbers right to the decimal point is rounded off.
2. 3 How to round one numbers from the right of the decimal point?
To round off one numbers from the right of the decimal point using formula, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Select any new cell namely B1, where the result want to display
STEP 3: Enter the formula in the cell B1 as =ROUND (A1, 1)
From the above worksheet the value 50.56 is rounded to 50.60is called nearest value, where the one number right to the decimal point is rounded off.
2.4 How to round three numbers from the left of the decimal point?
To round off three numbers from the left of the decimal point using formula, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Select any new cell namely B1, where the result want to display
STEP 3: Enter the formula in the cell B1 as =ROUND (A1, - 3)
From the above worksheet the value 5778.67 is rounded to 6000 is called nearest value, where the three numbers left to the decimal point is rounded off.
2.5 How to round two numbers from the left of the decimal point?
To round off two numbers from the left of the decimal point using formula, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Select any new cell namely B1, where the result want to display
STEP 3: Enter the formula in the cell B1 as =ROUND (A1,-2)
From the above worksheet the value 144.579 is rounded to 100 is called nearest value, where the two numbers left to the decimal point is rounded off.
2.6 How to round one numbers from the left of the decimal point?
To round off one numbers from the left of the decimal point using formula, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Select any new cell namely B1, where the result want to display
STEP 3: Enter the formula in the cell B1 as =ROUND (A1, -1)
From the above worksheet the value 1570.678 is rounded to 1570 is called nearest value, where the one numbers left to the decimal point is rounded off.
3. How to round the nearest whole numbers?
To round the nearest whole number using formula, the steps to be followed are,
STEP 1: Enter the data in the respective cell namely A1.
STEP 2: Select any new cell namely B1, where the result want to display
STEP 3: Enter the formula in the cell B1 as =ROUND (A1, 0)
From the above worksheet the value 570.5 is rounded to 571 is called nearest value, where the nearest whole number is rounded off.
4. How to use the ROUND function in division?
In division, the quotient obtained by dividing the whole numbers, is integer, decimal, whole number etc. To simplify and round off the result, ROUND function is used in division calculation.
STEP 1: Enter the data in the respective cell namely A1 and B1.
STEP 2: Select any new cell namely C1, where the result want to display
STEP 3: Enter the formula in the cell C1 as =ROUND (A1/B1, 0)
From the above spreadsheet, the result of dividing A1/B1 (68/ 3) is 22.66. The ROUND functions round off the value to 23. This process is called nesting inside the ROUND function. The formula or method which returns the numeric value is nested inside the ROUND function.
Summary
From the above tutorial, Excels default functions and formulas to round off the decimal value is clearly described.