Page 29 - Chinmaya_C6_flipbook
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
Input: =AVERAGE(10, 12, 14)
AVERAGE(range) It returns the average of a range of values.
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, fulfilled or not, and returns value1 if the Input: =IF(Percentage >=
value1, value2) condition evaluates to true, and returns 50, “Passed”, “Failed”)
value2 if the 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

