111. Various Methods of Rounding Numbers
Published Online: 11 NOV 2011
DOI: 10.1002/9781118257647.ch111
Copyright © 2010 Wiley Publishing, Inc., Indianapolis, Indiana
Book Title
John Walkenbach's Favorite Excel® 2010 Tips & Tricks
Additional Information
How to Cite
Walkenbach, J. (2010) Various Methods of Rounding Numbers, in John Walkenbach's Favorite Excel® 2010 Tips & Tricks, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257647.ch111
Publication History
- Published Online: 11 NOV 2011
- Published Print: 28 JUN 2010
ISBN Information
Print ISBN: 9780470475379
Online ISBN: 9781118257647
- Summary
- Chapter
Keywords:
- rounding numbers;
- Excel rounding functions;
- displayed value;
- mround function;
- formula
Summary
This chapter contains sections titled:
Rounding to the nearest multiple
Rounding currency values
Using the INT and TRUNC functions
Rounding to n significant digits