Page 269 - Computer - 9(A&B)

The colon (:) sign between two cell
addresses describes a continuous range e.g.,
the range (A1:C2) would include the cells
A1, B1, C1, A2, B2, and C2.

MAX( )
This function is used to fi nd the largest value in a series of numbers. The syntax of using this function is:
= MAX (Argument 1, Argument 2,…)
where MAX is the function name and arguments can be the cell range(s), cell references or constants.
For Example, = MAX (A1: A10) will return the largest number value among the numbers stored in the range of
A1 to A10.
= MAX (5, 6, 10, 4) will return 10.

If you do not pass any argument to the
Max( ) function, it returns 0 (zero).

MIN( )
MIN( ) works just opposite to MAX( ) function as it returns the smallest value among the given range. The
syntax of this function is same as MAX( ) function:
= MIN (Argument 1, Argument 2,…)
where MIN is function name and the arguments can be the cell range(s), cell references or constants.

For Example, = MIN(B10 : D14, E1: E10) will return the smallest number among the values present in the ranges
B10 to D14 and E1 to E10.

IF( )
IF( ) is a logical function which evaluates a logical expression for its truthness and returns a value among the two
options True or Flase. The syntax of this function is:
= IF (Conditional test, True_value, False_value)
Here, IF is the function name and ‘conditional test’ is the logical expression to be tested for its truthness.
True_value is the value returned in case the expressions evaluate to True and False_value is the value

returned if the condition stands False in the expression.
For Example, = IF (A10 < = 10, 2, 1)
In this statement, if the value in cell A10 will be less than or equal to 10, it will return 2 as a result whereas if the
value will be more than 10, the value returned will be 1.
Some other popular functions available in Calc are:

Function Name Description

POWER (Base, Exponent) Returns a where a is base raised to the power of exponent b.
b
PRODUCT (Number1, Number 2) Multiplies the arguments.

LOG (Number, Base) Calculates the logarithim to any specifi ed base.
FACT (Number) Calculates the factorial of a number.
COUNT (Arguments) Counts how many numbers are there in the list of arguments.

131
131