Page 89 - IT-802_class_12
P. 89

3.10.1 Mathematical Functions

            These functions perform mathematical calculations on the specified arguments. Some mathematical functions are:

                     Function                               Result (Considering a number as X)
              SUM(X;Y,...)            It  produces  the  sum  of  the  numbers  for  a  range  of  cells.  E.g.,  =SUM(C1  ...C4)  or
                                      =SUM(C1:C4) This will produce the addition of the cells from C1 to C4.

              ABS(X)                  It produces the positive (absolute) value of a given integer.
                                      E.g. =ABS(-8) returns 8, =ABS(4)=4, =ABS(-3.7) returns 3.7
              INT(X)                  It produces the integer value of a given integer.
                                      E.g. =INT(12.54) returns 12, =INT(-8.72) returns -9

              SQRT(X)                 It produces the square root of a positive integer.
                                      E.g. =SQRT(9) returns 3, =SQRT(2) returns 1.414213562

              ROUND(X;Y)              It produces the value of X that is rounded to the number of digits specified by Y.
                                      E.g. =ROUND(12.234;2) returns 12.23, =ROUND(32.67;0) returns 33
              MOD(X;Y)                It returns the remainder of X divided by Y.

                                      E.g. =MOD(11;2) returns 1, =MOD(90;2) returns 0
              POWER(X;Y)              It produces the value of X raised to the power of Y.
                                      E.g. =POWER(5;2) returns 25, =POWER(-5;5) returns -3125

              PRODUCT(X;Y)            It multiplies all the given arguments.
                                      E.g. =PRODUCT(5;2;3) returns 30, =PRODUCT(-5;6;0) returns 0
              LOG(n;b)                It calculates the log of a number n to base b.

              SIN(n), COS(n), TAN(n)  It calculates the sine, cosine, and tangent of n.
              RANDBETWEEN(f;l)        It returns a random number between f and l.

              QUOTIENT(a;b)           It calculates the integer quotient of division a/b.



                                                                                                   ICT Skills-IV  87
   84   85   86   87   88   89   90   91   92   93   94