Page 45 - ModularV1.1 _c6_flipbook
P. 45
Logical Functions
Functions 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 the given numbers Input: =AVERAGE(12,3,6)
AVERAGE(range)
in a range. Output: 7
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
Let us use the logical functions in MS Excel.
Perform the following steps to use the logical functions:
Step 1 Type the following data in the MS Excel worksheet.
Step 2 Type =MAX(B3:F3) function in the cell G3 to find the maximum marks.
Step 3 Press the Enter key from the keyboard.
When you press the Enter key, the maximum marks appear in the cell G3. Using the AutoFill
feature, find the maximum marks of each student. Similarly, we can find the minimum marks by
using the MIN() function.
Step 4 Type =AVERAGE(B3:F3) function in the cell I3 to find the average of marks.
Step 5 Press the Enter key from the keyboard.
Using AVERAGE function
When you press the Enter key, the
average of marks appears in the cell
I3. Using the AutoFill feature, we can
calculate the average of marks of each
Using MAX function
student.
Calculating average of marks
Formulas and Functions 43

