Page 24 - Trackpad_ipro 4.1_Class8
P. 24

Text Functions: These functions are used for manipulating text strings, such as combining,
                     trimming, changing the case of text, etc.

                      Logical Functions: These functions are used to perform logical tests and return logical values
                     (TRUE or FALSE).
                      Date and Time Functions: These functions help work with dates and times, allowing users to
                     extract and manipulate date and time information.
                      Lookup  and Reference Functions: These functions are  used to search  for and return
                     information from a specific range or table.
                      Financial  Functions:  These  functions  are  used  for  financial  calculations,  such  as  those
                     involving interest rates, loan payments, investments, depreciation, etc.

                      Information Functions: These functions return information about the data or the format,
                     location, or content of a cell.
                  Mathematical Functions


                           Function                           Purpose                             Example

                                               Adds up all the numbers in a  Input: =SUM(4,8,12,16)
                          SUM(range)
                                               specified range                         Output: 40
                                               Multiplies the numbers in a specified  Input: =PRODUCT(4,2,8)
                       PRODUCT(range)
                                               range                                   Output: 64
                                               Returns the remainder after dividing  Input: =MOD(8,5)
                    MOD(number, divisor)
                                               the number by the divisor               Output: 3
                                               Returns the square root of the given  Input: =SQRT(81)
                        SQRT(number)
                                               number                                  Output: 9

                                               Rounds the number  to the nearest  Input: =INT(14.25)
                         INT(number)
                                               integer                                 Output: 14

                                               Returns the result of the number  Input: =POWER(5,3)
                   POWER(number, power)
                                               raised to the given power               Output: 125

                       ROUND(number,           Returns a number after rounding it  Input: =ROUND(35.666,2)
                       number_of_digits)       to the specified digits                 Output: 35.67

                                               Returns  the  number  of  absolute  Input: =ABS(-25)
                         ABS(number)
                                               value of the given number               Output: 25



                   Tech

                     Funda


                                   In functions, we can also use the cell address in place of the values.






                    22     iPro (Ver. 4.1)-VIII
   19   20   21   22   23   24   25   26   27   28   29