Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    You can also use cell addresses to perform calculation in the following way:

                                                         Using cell addresses in formula
                     Notice that when the cell C1 is selected, the Formula bar shows the formula you just typed.

                        What appears in the cell is the result.
                         ✶ What appears in the formula bar is the value, which is a formula in this case.

                                                         Using cell addresses in formula
                     The elements of a formula are:
                        References: A cell or a range of cells that you want to use in your calculation.

                        Operators: Symbols (+, -, *, /, ^, $, %, etc.) that specify the calculations to be performed.

                        Constants: Numbers or text values that do not change.
                     Copying a Formula

                     There are two methods to copy a formula.
                     Using the Fill Handle

                     To copy a formula using the fill handle, follow these steps:

                     Step 1  Select the cell  that contains the formula, then position  the mouse  pointer over the
                              lower-right corner of the cell until the white cross (    ) appears.

                                                                                     Formulas and Functions in Calc      29

| 26 27 28 29 30 31 32 33 34 35 36 |