Page 29 - Trackpad_V2.1_Class6
P. 29
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 functions with their examples are given below:
Function Purpose Example
It returns the largest value in the given Input: =MAX(4,16,12,9)
MAX(range)
range. Output: 16
It returns the smallest value in the given Input: =MIN(4,16,12,9)
MIN(range)
range. Output: 4
It returns the average of numbers, specific Input: =AVERAGE(10, 12, 14)
AVERAGE(range)
cell references, ranges of cells. Output: 12
It returns the count of the number of values Input: =COUNT(4,8,12)
COUNT(range)
in the selected range. Output: 3
It checks whether the given condition is Percentage = 80
IF(condition, met, and returns value1 if the condition Input: =IF(Percentage > 50,
value1, value2) evaluates to true, and returns value2 if the “Passed”, “Failed”)
condition 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.
Formulas and Functions in Excel 2016 27

