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

