Page 29 - Trackpad_V1_Book 6_Flipbook
P. 29
For example, CONCATENATE () function:
2 Type =CONCATENATE(A1,B1)
function to concatenate two
strings using cell reference.
1 Type the following data.
LOGICAL FUNCTIONS
Some 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 checks whether the given condition is Percentage = 80
IF(condition, is met, and returns value1 if the condition Input: =IF(Percentage >=
value1, value2) evaluates to true, and returns value2 if the 50, “Passed”, “Failed”)
condition evaluates to false. Output: Passed
For example, MAX () function:
2 Type =MAX(C5:F5)
function in the cell G5.
1 Type the following data.
Now press the Enter key and maximum marks appear in cell G5. Similarly, we can find the
minimum marks by using the MIN() function.
Formulas and Functions in Excel 2010 27

