Page 52 - TP_Prime_v2.2_Class_6
P. 52

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:


           Prime (Ver. 2.2)-VI















          50






                                                       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 on the Sheet2 tab.

                  Step 3:  Click on the cell A2, and then press the Enter key. When you press the Enter key,
                           Sheet1 is now active.
   47   48   49   50   51   52   53   54   55   56   57