Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    FUNCTIONS AND ERRORS

                      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

                      Some of the rules for using functions in Calc are:

                          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

                      Some of the mathematical functions are given in the table below:

                                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

                       SQRT(Number)                   It returns the square root of the     Input: =SQRT(64)
                                                      given number.                         Output: 8

                     36     Premium Edition-VII

| 33 34 35 36 37 38 39 40 41 42 43 |