Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Formulas and
                              3                            Functions in Calc

                           Goal Glimpse

                               Formulas                                        Using a Text Formula
                               Order of Operation                              Cell Reference and Cell Range
                               Functions and Errors

                      In this chapter, you will learn how to create a basic formula in Calc. One of the Calc’s most
                      useful feature is that it allows users to create formulas in order to perform calculations on data.

                      Calc  also contains  built-in  formulas called  functions  that  make it  easy  to  perform  common
                      calculations on data.

                            FORMULAS

                      Formulas in Calc begin with an equal (=) sign. When the contents of a cell begin with equal to
                      sign, Calc understands that user has given a formula here. If you don’t enter the equal sign, Calc
                      will treat your entry as text and the calculation will fail. To show how formulas work, we'll begin
                      with a simple exercise by selecting blank cell A1.

                      Then type = 10 + 4 and press Enter key. As you press the Enter key, Calc performs the calculation
                      and produces the result as 14 in cell A1. Enter some more formula in other cells and see what
                      results are shown by Calc. For example:
                      1. =10 – 4           2. =10 * 4            3. =10/4              4. =10 ^ 4

                      The results will be 6, 40, 2.5 and 10000 respectively. Some formulas based on BEDMAS rule can
                      be entered as:
                      1. =(10 + 4) – (3 + 5) ^ 3

                      2. =(16/8) * (5 ^ 2) – 7

                       Clickipedia

                        LibreOffice Calc follows BEDMAS rule for doing mathematical calculations, where B stands

                        for Brackets, E for Exponentiation, D for Division, M for Multiplication, A for Addition and
                        S for Subtraction.

                     28     Premium Edition-VII

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