Page 32 - CG_v2.1_flipBooks_class_6
P. 32

Mathematical Functions


                   Function                    Purpose                              Example

                                                                                    Input: =SUM(4,8,12,16)
                   SUM(range)                  It returns the sum of a range.
                                                                                    Output: 40


                                               It multiplies the values in a range   Input: =PRODUCT(4,2,8)
                   PRODUCT(range)
                                               of cells.                            Output: 64

                                               It  returns  the  remainder  after  a   Input: =MOD(8,5)
                   MOD(number, divisor)
                                               number is divided by the divisor.    Output: 3

                                               It  returns  the  square  root  of  the   Input: =SQRT(81)
                   SQRT(number)
                                               given number.                        Output: 9


                                               It  removes  the  decimal  part  of  Input: =INT(14.25)
                   INT(number)                 the  number  and  returns  only  the   Output: 14
                                               integer part.

                                               It  returns  the  result  of  a  number   Input: =POWER(5,3)
                   POWER(number, power)
                                               raised to some power.                Output: 125

                                               It returns the count of the number   Input: =COUNT(4,8,12)
                   COUNT(range)
                                               of values in the selected range.     Output: 3


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

                                               It returns the absolute value of a   Input: =ABS(-25)
                   ABS(number)
                                               given number.                        Output: 25






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




                      30     Computer Genius (V2.1)-VI
   27   28   29   30   31   32   33   34   35   36   37