Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2632_CodeMind
P. 26

    Cell Referencing in Formulas and its types

                     A cell reference is a cell address that can be used in a formula to denote a specific cell. A formula
                     may contain references to other cells. In such a case, the result of a formula depends on the values
                     in the referenced cells. If you make any changes in the referenced cells, the result will be changed
                     automatically.

                     To see how this works:
                        • Enter 10 in cell A1.

                        • Now click on cell A2.
                        • Type =A1*2 in the formula bar.

                        • Press the ENTER key.

                     The value in cell A2 is 20.
                     If you change the value in cell A1 from 10 to any value, the value in cell A2
                     will also change.

                     Cell references are especially helpful when you create complex formulas.

                     There are three types of cell references used in Excel: relative, absolute, and mixed.

                     Relative References

                     By default, a cell reference is a relative reference. In relative reference, reference changes according
                     to the location of the cell. When the formula containing relative reference is copied to another cell,
                     the references adjust relative to the new cell of the formula.

                     To use the relative cell reference, follow the given steps:

                                                         2  Click on the Copy button.

                                 3  Select another
                                cell  in  which  you
                                want to copy the
                                formula and click
                                on   the   Paste
                                button.

                                                             1   Select  the  cell  that  contains  the  formula  in
                                                             which the reference of other cells is used.

                                                                                  Formulas and Functions in Excel  25

| 21 22 23 24 25 26 27 28 29 30 31 |