=ROUND(value,sigfigs-(1+INT(LOG10(ABS(value)))))
Rounding Significant Figures in Excel
Use the following formula to round a value to a certain number of sigfigs:
The New Excel Formulas Web Log
The purpose of this web log is to provide an archive of useful Microsoft Excel formulas. This log can provide a convenient method for quickly posting solutions to problems in Excel or linking to websites that contain useful formulas for solving a variety of problems in Excel.
The exciting thing about this web log is that it can be used for RSS newsfeeds to other websites. So, if you are an Excel consultant with your own internet presence, you can easily add dynamic content to your site using an RSS feed from this log.
Please contact me via my website (Vertex42.com) if you wish to add posts to this web log.
The exciting thing about this web log is that it can be used for RSS newsfeeds to other websites. So, if you are an Excel consultant with your own internet presence, you can easily add dynamic content to your site using an RSS feed from this log.
Please contact me via my website (Vertex42.com) if you wish to add posts to this web log.
Subscribe to:
Posts (Atom)
Posts
