Page 220 - CA_165_V2.0_C9_Flipbook
P. 220

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


                                2






                                                                                                       1




                                3















                  Step 2:   Click the Insert menu on the Menu bar.
                  Step 3:   Select the Function option from the drop-down menu.




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