# 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.

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

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

- 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.

- In cell C1, enter the formula provided above:

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

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

Did you find this useful?