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

