In this tutorial, you will learn how to round to significant figures in Excel.
After the decimal point, all the zeros to the right of the last non-zero digit are important. For instance, the number 0.0016300 has five significant digits. If the zeros to the right of the last non-zero digit are part of a measurement, they are all important.
Once you are ready, we can start by using real-life scenarios to help you understand how to round to significant figures in Excel.
Table of Contents
Round to Significant Figures in Excel
Before we begin we will need a group of data to be used to round to significant figures in Excel.
First, you need to have a clean and tidy group of data to work with.
In this example, we want to round the numbers to significant figures. To do so, we will insert the following formula =ROUND(A2,B2-(1+INT(LOG10(ABS(A2))))).
Once we are done, the formula rounds the numbers to significant figures.