Page 264 - open office
P. 264

Operator                                           Description

                :                                                Reference operator (as in A2:A2 )


                -                                                Negation operator

                 ,/                                              Multiplication, Division

                &                                                Text Concatenation


                 , ;                                             Argument Separator

                 ^                                               Exponent


                  ,-                                             Addition, Subtraction

                 >,<,>=,<=,<>                                    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.  E.g.,   SUM(C1  ...C4),
                SUM(    ...)
                                      SUM(C1:C4) (will produce the addition of cells from C1 to C4)

                ABS(X)               It produces the positive (absolute) value of a given integer.

                                     E.g.,  ABS(- )  ,  ABS(4) 4,  ABS(-3. ) 3.


                INT(X)               It produces the integer value of a given integer.
                                     E.g.,  I T(12.54) 12,  I T(- . 2) -


                S RT( )              It produces the square root of a positive integer.

                                     E.g.,  S RT( )   3,  S RT(2)   1.414213562

                ROU D(   )           It produces the value of   that is rounded to the number of digits specified by  .

                                     E.g.,  ROU D(12.234 2)  12.23,  ROU D(32.6   ) 33


                MOD(   )             It produces the remainder of X divided by Y.

                                     E.g.,  MOD(11 2)   1,  MOD(   2)

                POWER(   )           It produces the value of X raised to the power of Y.

                                     E.g.,  POWER(5 2) 25,  POWER(-5  .5)   UM!




               264      Touchpad Information Technology-IX
   259   260   261   262   263   264   265   266   267   268   269