How to Round to Significant Figures in Google Sheets

To round to significant figures in Google Sheets, you can use a combination of the ROUND and IF functions. Here's a step-by-step guide on how to do it.

1. Open Google Sheets and enter the number you want to round in cell A1.
2. In cell B1, enter the number of significant figures you want to round to.
3. In cell C1, enter the following formula:

=IF(A1=0, 0, ROUND(A1, B1 - 1 - INT(LOG10(ABS(A1)))))

4. Press Enter to apply the formula. The rounded number will be displayed in cell C1.

##Example

Let's say you have the following data in your Google Sheets document:

A1: 123.456
B1: 3

Now, you want to round the number in A1 to 3 significant figures.

1. In cell C1, enter the formula provided above:

=IF(A1=0, 0, ROUND(A1, B1 - 1 - INT(LOG10(ABS(A1)))))

2. Press Enter to apply the formula.
3. The result in cell C1 will be 123, which is the number in A1 rounded to 3 significant figures.