So far we have learned the many formulate round a number in Excel. Now we are going to see the formula which helps to round a number to N significant digits (such as a given number of specified digits) in Excel. Let’s step them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- Use the below formula to round a number based on specified digits in Excel.
=ROUND(number,digits-(1+INT(LOG10(ABS(number)))))
Syntax Explanations:
- ROUND – This function will help to round a number to the specified number of digits. Read more on the ROUND Function.
- INT – In Excel, the INT function is used to round a given integer number down to the nearest integer.
- LOG10 – The LOG10 Function helps to return the base10 logarithm of a given number.
- ABS – The ABS (Absolute) function returns the absolute value of a number.
- Number – It represents the input values from your worksheet.
- Digits – This is the value that specifies how many digits to be rounded.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Let’s consider the below example image.
- Here, we will enter the input values in Column B.
- Now we are going to round the value based on specified digits which are given in Column C.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell.
Bottom-Line:
Hope you like this article on how to round a number to N significant values in Excel. If you feel this article is useful, then leave feedback in the below comment section. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)