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

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

message edited by mmcconaghy

That's brilliant Mike, thank you very much

Ask Your Question

Weekly Poll