Page 91 - IT-802_class_12
P. 91

3.10.4 Logical Functions

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

                Function                                           Result

                OR         If any of the conditions enclosed in brackets is true, it returns TRUE; otherwise, it returns FALSE.
                           E.g. =OR(5>3; 4<5;4>15) will display TRUE
                           =OR(3>6;2<1) will display FALSE

                AND        If all the conditions enclosed in brackets are true, it produces TRUE; otherwise, it produces FALSE.
                           E.g. =AND(5>3;4<5;4>15) will display FALSE. (As one of the conditions 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; otherwise, it will display the
                           false part.

                           E.g. =IF(4>5;4;5) will display 5 since the condition is false.

              3.11 DATA MANIPUlATION

            Spreadsheets provide different functions and options through which data can be manipulated according to the need or
            requirement. Data is used for calculation, graphical representation, and to display information.
            3.11.1 Performing Calculation

            A Spreadsheet can be used to perform different types of calculations. To perform a calculation, the ‘=’ (is equal to)
            symbol is used, which indicates a formula has been used and the calculation is to be done. There are different ways in
            which calculations can be performed.
            Ð ÐBy using operators
            Ð ÐBy using functions
            Calculation by using the Operators

            To perform any multiplication:
             1   Click on the cell where the output of the multiplication is to be shown or generated.







                                                                                           1



















                                                                                                   ICT Skills-IV  89
   86   87   88   89   90   91   92   93   94   95   96