Note
The following formula calculates N significant figures
ROUND( YOUR CELL , PRECISION -(1+INT(LOG10(ABS( YOUR CELL )))))
CITE: https://exceljet.net/formula/round-a-number-to-n-significant-digits
values | results | comments |
---|---|---|
123456789 |
|
|
123456789 |
| ROUND(a2,3-(1+INT(LOG10(ABS(a2))))) |
123800210 |
| ROUND(a3,3-(1+INT(LOG10(ABS(a3))))) |
13.123 |
| ROUND(a4,3-(1+INT(LOG10(ABS(a4))))) with a format, “#.#” |
13 |
| ROUND(a5,3-(1+INT(LOG10(ABS(a5))))) with a format, “#.#” |
123456789 |
| |
Add Comment