Page 58 - TP_Prime_v2.2_Class_6
P. 58
Logical Functions
Function Purpose Example
IF(condition, It checks whether the given Percentage = 80
value1, value2) condition is met, and returns Input: =IF(Percentage >= 50,
value1 if the condition evaluates “Passed”, “Failed”)
to true, and returns value2 if the
Output: Passed
Prime (Ver. 2.2)-VI Statistical Functions
condition evaluates to false.
Function
Purpose
Example
MAX(range) It returns the largest value in Input: =MAX(4,16,12,9)
the given range.
56 Output: 16
MIN(range) It returns the smallest value in Input: =MIN(4,16,12,9)
the given range. Output: 4
AVERAGE(range) It returns the average of the Input: =AVERAGE(12,3,6)
given numbers in a range. Output: 7
It returns the count of the Input: =COUNT(4,8,12)
COUNT(range) number of values in the selected
range. Output: 3
Let us use the Statistical functions in Excel.
Perform the following steps to use the Statistical functions:
Step 1: Type the following data in the 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.
Using MAX Function

