EVALUATION MEANING, SYNTAX AND EXAMPLE FOR SOME OPEN OFFICE CLAC 1. AVERAGE SYNTAX: =AVERAGE(Initial cell of cell address range: last cell of the cell address range) EXAMPLE: 12
3
34
45
67
77
2. MINIMUM SYNTAX: =MIN(Initial cell of cell address range: last cell of the cell address range) EXAMPLE: 12
3
34
45
67
77
3. QUOTIENT SYNTAX: = QUOTIENT(cell address : cell address) EXAMPLE: 50
2
25
4. POWER SYNTAX: = POWER(cell address ; cell address) EXAMPLE: Power 2 2 2
4
5.ROUND SYNTAX: = ROUND(cell address ; Up to which decimal you want to round up) EXAMPLE: 2.35
6. OR SYNTAX: = (Condition 1) OR (Condition 2) EXAMPLE: If 4>1 or 7<1 Then, answer is as follow: =true + flase =1+0 =1
2.3
3