Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 34 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 34

    Absolute References

                      In case, if you wish to maintain the original references as they were, then you should make use
                      of the absolute references. If you want to make the above example retain the original reference
                      when it is copied, then you should precede the columns reference and the row reference by a

                      Dollar ($) symbol, i.e., you should use the formula as = $D$3 + $E$3 so that when you copy the
                      formula the original reference is retained. For example, if you copy or fill an absolute reference
                      in cell C2 to cell C3, it stays the same in both cells = $B$2.
                      Mixed References

                      In some situations, you may need to make the cell  reference  as ‘Mixed’ reference,  so  that
                      you can lock either a column or a row by preceding it with a Dollar ($) symbol. It is basically

                      a  combination  of  relative  and  absolute  references.  For  example,  if you  use a  formula  as
                      = $D$4 + E4, then you are making the value that is present in cell D4 as absolute and the value
                      in cell E4 as Relative.
                      Using Cell Reference of Other Spreadsheet

                      Suppose you have a spreadsheet named Sheet1 with data and you want to refer to the content
                      in Sheet2. You can use the following syntax:
                      SheetName.CellAddress

                      Suppose you have a spreadsheet with the following column names Customer Name, Product
                      Name, Quantity and Price.

                      Now if you want to display the Total Amount of each Customer in another spreadsheet Sheet2.
                      To reference a cell in another spreadsheet, follow these steps:

                      Step 1  Click on the cell where you want the reference result to appear.

                      Step 2  Type the cell reference formula:
                               =Sheet1.C2*Sheet1.D2

                      Step 3  Press the Enter key.

                     32     Premium Edition-VII

| 29 30 31 32 33 34 35 36 37 38 39 |