Page 25 - Trackpad_V5_Book 6
P. 25

For example, a formula (=A2*B2) placed in cell C2 multiplies the values of cells A2 and B2. As we
            press the Enter key, the result of the multiplication of values in A2 and B2 is displayed in cell C2.

            If we copy the formula (=A2*B2) in cell C3, then the cell references in the formula (=A2*B2) change
            in relation to the new location of the formula, and the result is displayed according to the changed

            cell reference.





                                                                                       After copying and pasting
                                                                                        the formula in cell C3,
                                                                                          cell references are
                                                                                        automatically adjusted.

                                Result of formula
                               (=A2*B2) in cell C2


            ABSOLUTE CELL REFERENCING                                    Typing the formula (=$A$2 + $B$2)

            In  absolute cell referencing, cell references in the        in cell C2 for absolute referencing
            formula remain the same even if we copy and paste the
            formula to a new location. It is used when you maintain
            the original references as they were. For this, we need

            to use the $ (dollar) sign as a prefix before the column
            name and row numbers in the formulas.
            For example, if we want the value of A1 to be  constant
            when multiplying it with a cell from column B, absolute

            referencing will be used.
            When the formula (=$A$2*$B$2) in cell C1 is copied            Displaying constant result after copying
            and pasted to C2, the values in cells A2 and B2 remain            and pasting formula in cell C3

            unchanged.

            MIXED CELL REFERENCING

            A  mixed cell reference refers  to  a specific  row  or
            column. It is basically a combination of relative and
            absolute references. There are times when we may
            want a part of the cell reference to change when the
            formula is copied.

            In some situations, you may need to make the cell
            reference as a ‘Mixed’ reference, so that you can lock
            either a column or a row by preceding it with a Dollar

            ($) symbol.  For example,  when the  column  letter                           Typing the formula using
            changes, the row stays constant or vice versa.                                 a mixed cell reference




                                                                            Formulas and Functions in Excel 2021  23
   20   21   22   23   24   25   26   27   28   29   30