Page 266 - open office
P. 266
MIN( ) Produces the smallest value from the given set of values/range of cells. E.g., =
MI (1 2 15 25) Displays output:1
MI (A1 A2 A3) Displays the smallest value of cells A1, A2 A3.
=MIN(B2:C3) Displays the smallest value of cells B2, B3, C2 & C3.
COU T() Produces the number of arguments enclosed in small brackets. E.g., =
COU T(1 2 15 25 3 6) Displays output :6
COU T(A1:A2 ) Displays output: 2 (If all cells i.e., A1 to A2 contain values).
Logical Functions
ogical Functions in OpenOffice Calc check the data and return the result TRUE if the condition is true, and
FA SE if not. Consider the syntax of logical functions and examples of their applications in the process of
working with the Calc program.
Function Result
Produces TRUE if any condition enclosed in the bracket is TRUE, otherwise it produces FA SE.
OR E.g., OR(5 3 4 5 4 15) will display TRUE.
OR(3 6 2 1) will display FA SE.
Produces TRUE if all the conditions enclosed in the bracket are TRUE, otherwise displays FA SE.
AND E.g., A D (5 3 4 5 4 15) will display FA SE. (As one of the conditions is FA SE)
A D(5 3 4 5) will display TRUE. (As all the conditions are TRUE)
If the condition in the statement is TRUE, it will display the TRUE part otherwise it will display
IF the FA SE part.
E.g., IF(4 5 4 5) will display 5 since the condition is FA SE.
ENTERING FUNCTION IN A CELL
Functions are entered in in a cell to produce the output of data.
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’. ‘=’ sign will appear in the ‘Formula bar’ and the ‘Functions Wizard’ will open.
On the left side of the wizard, different categories for the type of data, calculation or analysis are displayed
like: Database, Date and Time, Financial, ogical, Mathematical, Statistical, Text, etc.
266 Touchpad Information Technology-IX

