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

