Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Functions                          Purpose                            Example

                      INT(Number)                    It rounds down the number to an       Input: =INT(17.95)
                                                     integer value.                        Output: 17

                      POWER(Base, Exponent)          It returns the result of a base       Input: =POWER(3,4)
                                                     raised to some exponent.              Output: 81

                     Text Functions

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

                             Functions                        Purpose                             Example

                      CONCATENATE(Text1,  It joins together two or more                Input: =CONCATENATE
                      Text2)                     different text strings.               (“Libre”,“Office”)
                                                                                       Output: LibreOffice

                      LEFT(Text, Number)         It returns the specified number       Input: =LEFT(“LibreOffice”,4)

                                                 of characters from the left side of  Output: Libr
                                                 the text string.

                      RIGHT(Text, Number)        It returns the specified number of  Input: =RIGHT(“LibreOffice”,4)
                                                 characters from the right side of     Output: fice
                                                 the text string.

                      MID(Text, Start, Steps) It returns the specified number of  Input: =MID(“LibreOffice”,4,7)
                                                 characters from the given point       Output: reOffic
                                                 to the given number of steps.

                      LEN(Text)                  It returns the length of the text     Input: =LEN(“LibreOffice”)
                                                 string.                               Output: 11

                      UPPER(Text)                It converts the text string into      Input: =UPPER(“LibreOffice”)
                                                 upper case.                           Output: LIBREOFFICE

                      LOWER(Text)                It converts the text string into      Input: =LOWER(”LibreOffice”)
                                                 lower case.                           Output: libreoffice

                     Statistical Functions

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

                           Functions                        Purpose                                Example

                      MAX(range)            It returns the largest value in the       Input: =MAX(16,21,18,7,13)
                                            given range.                              Output: 21

                                                                                     Formulas and Functions in Calc      37

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