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

Logical Functions


                  Logical Functions in OpenOffice Calc check the data and return the result TRUE if the condition is true,
                  and FALSE if not. Some of the logical functions are:
                       Function                                           Result

                    OR               Produces true if any condition enclosed in bracket is true, otherwise it will produce
                                     false.
                                     Eg. =OR(5>3; 4<5;4>15) will display true.
                                     =OR(3>6; 2<1) will display false.

                    AND              Produces true if all the conditions enclosed in bracket is true  otherwise it will
                                     display false.
                                     Eg.=AND(5>3; 4<5; 4>15) will display false. (As one of the condition is false)
                                     =AND(5>3; 4<5) will display true. (As all of the conditions are true.)

                    IF               If  the  condition  in  the  statement  is  true,  it  will  display  the  true  part  (first  part
                                     after the condition) otherwise it will display the false part (second part after the
                                     condition).
                                     Eg. =IF(4>5;4;5) will display 5 since the condition is false.


                    ENTERING A FUNCTION IN A CELL

                  Functions are entered in a cell to produce the output, by following the given steps:
                  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’.

                  Step 3:   ‘=’ sign will appear in the ‘Formula Bar’ and ‘Functions Wizard’  will open.
                  Step 4:     On the left side of the wizard, different types of category for type of data or calculation or
                            analysis is displayed like: Database, Date and Time, Financial, Logical, Mathematical, Statistical,
                            Text, etc. On the right side; corresponding in-built function is displayed. Eg.:SUM (Number1;
                            Number2;....)

                  Step 5:   Select the ‘Category’ as ‘Mathematical’ from the list box.

                  Step 6:   Select the ‘SUM’ function.


                   204    Touchpad Computer Applications-IX
   201   202   203   204   205   206   207   208   209   210   211