Solved A formula in excel to round any number to 3 significant figs

May 8, 2017 at 02:44:56
Specs: Windows 7
Hi
I am hoping someone can help with a single formula to round any number to 3 significant figures i.e.
120.78 rounds to 121
58.75 rounds to 58.8
1.117 rounds to 1.12
0.237112 rounds to 0.237

See More: A formula in excel to round any number to 3 significant figs

Report •

#1
May 8, 2017 at 05:53:32
✔ Best Answer
Something like:

=ROUND(A1,3-(1+INT(LOG10(ABS(A1)))))

But, the explanation can be a bit complicated, see here:

https://exceljet.net/formula/round-...

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
May 8, 2017 at 07:13:36
That's brilliant Mike, thank you very much

Report •
Related Solutions


Ask Question