Page 204 - CA 165 ver 1.0 Class 9
P. 204

Operator                 Description                       Operator             Description

                    :            Reference operator (as in A2:A20)          , ;                Argument Separator


                    -            Negation operator                          ^                  Exponent

                    *,/          Multiplication, Division                   +,-                Addition, Subtraction

                    &            Text Concatenation                         >,<,>=,<=,<>       Comparison operator


                  Mathematical Functions


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


                     Function                               Result (Considering a number as X)

                                     It produces the sum of the numbers for a range of cells.
                     SUM(X;Y;...)
                                     Eg. = SUM(C1 ...C4), SUM(C1:C4) (will produce the addition of cell from C1 to C4)
                                     It produces the positive (absolute) value of a given integer.
                     ABS(X)
                                     Eg. = ABS(-8) = 8, ABS(4) = 4, ABS(-3.7) = 3.7
                                     It produces the integer value of a given integer.
                     INT(X)
                                     Eg. = INT(12.54) = 12, INT(-8.72) = -9
                                     It produces the square root of a positive integer.
                     SQRT(X)
                                     Eg. =SQRT(9) = 3, = SQRT(2) = 1.414213562
                                     It  produces  the  value  of  X  that  is  rounded  to  the  number  of  digits  specified

                     ROUND(X;Y)      by Y.
                                     Eg. = ROUND(12.234;2) = 12.23, ROUND(32.67;0) = 33
                                     It produces the remainder of X divided by Y.
                     MOD(X;Y)
                                     Eg. = MOD(11;2) = 1, MOD(90;2) = 0

                                     It produces the values of X raised to the power of Y.
                     POWER(X;Y)
                                     Eg. = POWER(5;2) = 25, POWER(-5;0.5) = #NUM!
                                     It multiplies all the given arguments.
                     PRODUCT(X;Y)
                                     Eg. = PRODUCT(5;2;3) = 30, PRODUCT(-5;6;0) = 0


                            Notes


                            AUTOSUM (Σ) is a shortcut tool for adding the values of a range of Cells. To do so:
                            Select the range of cells to be added, click on the Autosum button (Σ) near formula bar. The sum is
                            displayed in the next cell.









                   202    Touchpad Computer Applications-IX
   199   200   201   202   203   204   205   206   207   208   209