Page 266 - open office
P. 266

MIN( )          Produces the smallest value from the given set of values/range of cells. E.g., =
                                 MI (1  2  15 25) Displays output:1

                                  MI (A1 A2 A3) Displays the smallest value of cells A1, A2   A3.
                                 =MIN(B2:C3) Displays the smallest value of cells B2, B3, C2 & C3.
                 COU T()         Produces the number of arguments enclosed in small brackets. E.g., =
                                 COU T(1 2 15 25 3 6) Displays output :6

                                  COU T(A1:A2 ) Displays output: 2  (If all cells i.e., A1 to A2  contain values).


              Logical Functions
               ogical Functions in OpenOffice Calc check the data and return the result TRUE if the condition is true, and
              FA SE if not. Consider the syntax of logical functions and examples of their applications in the process of
              working with the Calc program.


                Function                                             Result
                           Produces TRUE if any condition enclosed in the bracket is TRUE, otherwise it produces FA SE.

               OR          E.g.,  OR(5 3  4 5 4 15) will display TRUE.
                            OR(3 6  2 1) will display FA SE.

                           Produces TRUE if all the conditions enclosed in the bracket are TRUE, otherwise displays FA SE.

               AND         E.g., A D (5 3  4 5  4 15) will display FA SE. (As one of the conditions is FA SE)
                            A D(5 3  4 5) will display TRUE. (As all the conditions are TRUE)

                           If the condition in the statement is TRUE, it will display the TRUE part otherwise it will display

               IF          the FA SE part.
                           E.g.,  IF(4 5 4 5) will display 5 since the condition is FA SE.

                ENTERING FUNCTION IN A CELL

              Functions are entered in in a cell to produce the output of data.

              Step 1:   Select the cell in which the output has to be displayed or function is to be inserted. (here, cell G2 has
                      been selected to enter the function.)















              Step 2:  Select the option ‘Function’ from the  Insert  menu.  Or , click on the  fx  button from the  Formula
                      Bar’. ‘=’ sign will appear in the ‘Formula bar’ and the ‘Functions Wizard’  will open.
                On the left side of the wizard, different categories for the type of data, calculation or analysis are displayed
              like: Database, Date and Time, Financial,  ogical, Mathematical, Statistical, Text, etc.



               266      Touchpad Information Technology-IX
   261   262   263   264   265   266   267   268   269   270   271