ROUND

Command: ROUND

 

Syntax: =round(cell to round, digits to round to)

 

Example 1:

# to be rounded: 1.45 (or cell a1)

Formula is =round(a1,1) --> asking excel to round 1.45 to 1 digit

Result in Excel: 1.50

 
Sitemap | Privacy | Terms
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)