Page 41 - TP_Pluse_V2.2_Class_6
P. 41

For example, if you want to give a discount of 10% on each product, then the discount will remain the
                 same for all the products. To calculate the amount to be paid, you should add the Dollar ($) sign with
                 the cell that contains the discount percentage. In this case, the discount percentage is given in cell D3.
                 Hence, the formula will be =((B3*C3)-((B3*C3)*($D$3))).
                 When you copy the formula to the next cell, the address of the cell D3 will remain the same as shown:



























                                                       Using absolute referencing
                      Mixed References


                 A mixed reference is a reference that refers to a specific row or column. It is basically a combination of
                 relative and absolute references. In some situations, you may need to make the cell reference as ‘Mixed’
                 reference, so that you can lock either a column or a row by preceding it with a Dollar ($) symbol.
                 For example, $A1 or A$1.


                       REFERENCES TO OTHER WORKSHEETS


                 You can refer to cells in other worksheets within the same workbook just as easily as you refer to cells
                 in the same worksheet.
                 For example, to enter a reference to cell A2 in Sheet2 into cell A1 in Sheet1, do this:

                 Step 1:  Select cell A1 in Sheet1, and type an equal (=) sign.
                 Step 2:  Click the Sheet2 tab.
                 Step 3:  Click cell A2, and then press the Enter key. When you press the Enter key, Sheet1 is now active.

                 Step 4:  Select cell A1, and you will see that it contains the formula = Sheet2! A2.
                 The exclamation point separates the worksheet portion of the reference from the cell portion.


                                                             Tech Hint

                     To switch between making the column, the row, or nothing ‘Absolute’: press the F4 key
                     repeatedly over a reference (cell).




                                                                               Formulas and Functions in Excel 2016  39
   36   37   38   39   40   41   42   43   44   45   46