Little Known Excel Shortcut #12
By BankersBall on Jul 31, 2007 in Excel, Excel Shortcuts
 |
SHORTCUT:
=ROUND(A1,A2-1-INT(LOG10(ABS(A1))))
where A1 = cell containing value you want to round and A2 = number of significant digits.
PURPOSE:
Round a number to __ significant digits.
FURTHER EXPLANATION:
ROUND(), ROUNDUP() and ROUNDDOWN() allow you to round but not preserve a specified number of significant digits. Source: OzGrid.
On Aug 1, 2007, Julius Seizure said:
Maybe a less convoluted way of doing that would be
ROUND(A1,A2-LEN(TEXT(A1,0)))
Thanks for nothing!
On Aug 4, 2007, Me said:
Hmm … can’t you just adjust the format to the required d.p s? this reminds of the story of the russian pencil versus the american anti-gravity pen
On Nov 2, 2007, blah said:
Why not just use the =MROUND() function.
E.g., if you want to round $1,234,567 to the nearest 1000 you type =mround(1234567,1000)