Page 27 - ThinkGPT_V2.1_C6_Flipbook
P. 27

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
   22   23   24   25   26   27   28   29   30   31   32