Page 22 - iPlus_Ver_2.0_class_8
P. 22

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 to 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:





















                      Quick Byte

                      Pressing the F4 key repeatedly over a reference (cell) will allow you to switch between
                      making the column, the row, or nothing ‘Absolute’.


                  Mixed References

                  This type of cell referencing is the combination of absolute and relative referencing. While applying
                  mixed referencing, either the row number or the column name of the cell address in the formula
                  is fixed. The cell references such as $F5 or F$5 are examples of mixed referencing. $F5 means that
                  the column F is absolute and row 5 is relative while F$5 means that the column F is relative and
                  row 5 is absolute.
                  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, follow the given steps:
                  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.
                  Other Workbook References

                  You can refer to cells in a worksheet in other workbooks in the same way you refer to
                  cells in other worksheets within the same workbook. These references are called external
                  references.


                    20
                         iPlus (Ver. 2.0)-VIII
   17   18   19   20   21   22   23   24   25   26   27