Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Advanced Functions

Creating a ROUND function



P ROCEDURES

1. Select the cell in which you want the result of the ROUND function to appear. 2. Type =round and an open parenthesis ( ( ). 3. Type the value, formula, cell address, or function you want to round, followed by a comma. 4. Type the desired number of decimal places. 5. Type the closing parenthesis ( ) ). 6. Press [Enter] .



S TEP - BY -S TEP

Use the ROUND function.

Display the Invest worksheet.

Steps

Practice Data

1. Select the cell in which you want the result of the ROUND function to appear. The cell is selected.

Click cell F7

OFFICEPRO, Inc.

Page 91