Page 22 - iprime_V2.2_class8
P. 22

Absolute References

                  To maintain the original references when copying a formula, use absolute references. This ensures
                  that the cell references do not change. To create an absolute reference, precede both the column
                  letter and the row number with a dollar sign ($).

                  Suppose you want to apply a discount of 10% to each product. The discount percentage is located
                  in cell D3. To calculate the amount to be paid after applying the discount, use the following
                  formula: =((B3*C3)-((B3*C3)*($D$3))).

                  When you copy this formula to another cell, the reference to D3 will remain unchanged.
























                                                        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 a
                  ‘Mixed’ reference so that you can lock either a row or a column by preceding it with a Dollar ($) sign.

                  For example, $A1 or A$1
                  References to Other Worksheets

                  You can refer to cells in other worksheets within the same workbook easily, just like referring to
                  cells in the same worksheet.

                  To reference a cell in another worksheet, follow these steps:
                  Step 1  Select the cell where you want to enter the reference, such as A1 in Sheet1.
                  Step 2  Type an equal sign (=).

                  Step 3  Click on the tab for the other worksheet (e.g., Sheet2).
                  Step 4  Click on the cell you want to reference (e.g., A2 in Sheet2).

                  Step 5  Press the Enter key.
                         You will return to Sheet1.
                  Step 6  Click on cell A1, and you will see the formula in the formula bar =Sheet2!A2.

                  The exclamation point separates the worksheet portion of the reference from the cell portion.


                  20     iPRIME (Ver. 2.2)–VIII
   17   18   19   20   21   22   23   24   25   26   27