Excel 2016 Tips and Tricks

Lesson 3 – Using Advanced Functions

Excel 2016

Steps

Practice Data

2. Type =round and an open parenthesis ( ( ).

Type =round(

=round( appears in the cell and on the formula bar.

3. Type the value, formula, cell

Type d7,

address, or function you want to round, followed by a comma. The text appears in the cell and on the formula bar.

4. Type the desired number of decimal places.

Type 4

The text appears in the cell and on the formula bar.

5. Type the closing parenthesis ( ) ). The closing parenthesis ( ) ) appears in the cell and on the formula bar.

Type )

6. Press [Enter] .

Press [Enter]

The result of the ROUND function appears in the cell.

Notice that the number in cell G7 differs from that in cell E7 because it is based on the rounded number in cell F7. Then, copy the formula to the range F8:F12.

Select the range D7:D12 and click the Decrease Decimal button in the Number group on the Home tab twice to format the numbers for four decimal places. Notice that the values in column E do not change; the calculations are still based on the full number of decimal places. Use the Undo feature twice to remove the formatting.

L IMITING THE P RECISION OF N UMBERS  D ISCUSSION

To calculate a worksheet using the numbers as they are displayed, you can limit the precision of formatted numbers. Limiting the precision changes the actual values in the worksheet to their formatted versions. For example, if a cell containing an actual value of 123.4567 is formatted with no decimal places, only 123 will display. In a calculation, however, Excel will still use 123.4567 (the entire number, including all decimal places). If you limit the precision of the cell to the formatted value, Excel will use only the formatted value ( 123 ) in calculations and will remove all decimal places in the stored number.

Page 92

OFFICEPRO, Inc.