Page 34 - Computer Genius Class 06
P. 34
Logical Functions
Functions Purpose Example
Input: =MAX(4,16,12,9)
MAX(range) t returns the largest alue in the gi en range.
Output: 16
Input: =MIN(4,16,12,9)
MIN(range) t returns the smallest alue in the gi en range.
Output: 4
AVERAGE It returns the average of the given numbers in a Input: =AVERAGE(12,3,6)
(range) range. Output:
It checks whether the given condition is met, Percentage = 80
IF(condition, and returns value1 if the condition evaluates to Input: =IF(Percentage >= 50,
value1, value2) true, and value2 if the condition evaluates to “Passed”, “Failed”)
alse. Output: Passed
et us use the logical unctions in cel.
To use the logical functions, follow the given steps:
1 Type the following
data in the Excel
or sheet.
2 Type =MAX(B3:F3) function to find the
ma imum mar s and press the Enter ey.
When you press the Enter ey the ma imum mar s appear in cell G3. sing the AutoFill feature,
find the ma imum mar s o each student. imilarly e can find the minimum mar s y using the
MIN() unction.
32 Computer Genius-VI

