Excel 2016 Tips and Tricks
Excel 2016
Lesson 3 – 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
Made with FlippingBook flipbook maker