Page 218 - CA_165_V2.0_C9_Flipbook
P. 218

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) (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.




                   216   Touchpad Computer Applications (Ver. 2.0)-IX
   213   214   215   216   217   218   219   220   221   222   223