Page 65 - TechPluse_C6_Flipbook
P. 65

This  is  because  Calc  calculates  the  expression  (20  +  20)  within  the  parentheses  first.  It  then
                 multiplies by 3. If you are unsure of the order in which Calc calculates, use parentheses even if

                 the parentheses aren’t necessary. Parentheses also make your formulas easier to understand.

                     FUNCTIONS

                 Functions are predefined formulas in Calc to perform both simple and complex calculations.
                 They accept arguments and return values. Arguments are input to functions. These values can be
                 number or text. The values are given in parenthesis. Return values display the function output.
                 Rules for using Functions


                    All Calc functions must begin with = sign
                    Function name must be a valid Calc name.
                    Function must be followed by opening and closing parenthesis.

                    Functions must contain an argument within it.
                 Type of Functions

                 LibreOffice Calc provides the following categories of functions:
                     Date & Time Functions: Calculates the day, month and year in a date and the hour, minute

                     and second in a particular time.
                    Logical Functions: Evaluates conditions such as Y < 3 and give the result as true or false.
                     Mathematical Functions: Calculates the square root or absolute value of a number, product

                     of numbers, etc.
                     Statistical Functions: Calculates the maximum, minimum, average, etc. of a set of numeric data.
                     Text Functions: Performs a number of operations on strings (i.e. a collection of characters
                     like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two strings,
                     searching for one string inside another etc.

                 Let us discuss these categories in detail.
                 Mathematical Functions


                           Functions                          Purpose                            Example

                  SUM`(Number1, Number  It returns the sum of given                    Input: =SUM(3,6,9,12)
                  2, …) OR SUM(Range)            numbers or a range.                   Output: 30


                  PRODUCT(Number1,               It multiplies the given values or a   Input: =PRODUCT(2,5,9)
                  Number 2, …) OR                range of cells.                       Output: 90
                  PRODUCT(Range)

                  MOD (Dividend, Divisor)        It returns the remainder after a      Input: =MOD(15,7)
                                                 dividend is divided by the divisor.   Output: 1






                                                                        Formulas, Functions and Charts in Calc       63
   60   61   62   63   64   65   66   67   68   69   70