Page 25 - Touchpad_Plus_V3.2_Class 7
P. 25

Functions                          Purpose                            Example

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

                  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 to  Output: reOffic
                                              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
                  MIN(range)            It returns the smallest value in the      Input: =MIN(16,21,18,7,13)
                                        given range.                              Output: 7
                  AVERAGE(range)        It gives the average of the given         Input: =AVERAGE(16,21,18,7,13)
                                        numbers in a range.                       Output: 15
                  COUNT(Number1,  It returns the count of the number of  Input: =COUNT(6,4,8,9,7)
                  Number 2, …) OR  given values or values in the selected  Output: 5
                  COUNT(range)          range.


                                                                        Formulas, Functions and Charts in Calc       23
   20   21   22   23   24   25   26   27   28   29   30