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

