Page 30 - KEC Khaitan C6 Flipbook
P. 30
For example, CONCATENATE () function:
2 Type =CONCATENATE(A1,B1)
function to concatenate two
strings using cell reference.
1 Type this data.
STATISTICAL AND LOGICAL FUNCTIONS
Some statistical and logical with their examples are given below:
Function Purpose Example
It returns the largest value in the given range Input: =MAX(4,16,12,9)
MAX(range)
of numbers. Output: 16
It returns the smallest value in the given range Input: =MIN(4,16,12,9)
MIN(range)
of numbers. Output: 4
Input: =AVERAGE(10, 12, 14)
AVERAGE(range) It returns the average of a range of numbers.
Output: 12
It returns the count of the number of values in Input: =COUNT(4,8,12)
COUNT(range)
the selected range. Output: 3
It checks whether the given condition is met, Percentage = 80
IF(condition, value1, and returns value1 if the condition evaluates Input: =IF(Percentage >= 50,
value2) to true, and returns value2 if the condition “Passed”, “Failed”)
evaluates to false. Output: Passed
For example, MAX () function:
2 Type =MAX(B3:F3)
function in the cell G3.
1 Type this data.
Now press the Enter key and the maximum marks appear in cell G3. Similarly, we can find the
minimum marks by using the MIN() function.
28 Premium Edition-VI

