Скачать или смотреть How to use RANK function in Excel In Tamil

How to use RANK function in Excel

Step 1

MIN function to be used for find out the marks 35 and above if the result is TRUE

if the mark is below 35 the result is FALSE

=MIN(select all subject of a student)Above=35

Step 2

AVERAGE function to be used find out the average mark of a student

=AVERAGE(select all subject of a student)

Step 3

IF function to find the average of PASS students, if the student FAIL in any one subject the result is FALSE, so so far false value give nothing

Step 4

RANK function to use find If the student Pass give the Rank, Otherwise No Rank

How to use Sum function in Excel In Tamil    • How to use Sum function in Excel In Tamil  
How to Use IF function in Excel in Tamil    • How to Use IF function in Excel in Tamil  
How to Use SumIf function in Excel in Tamil    • How to Use SumIf function in Excel in Tamil  
How to use AND, IF function in Excel in Tamil    • How to use AND, IF function in Excel in Tamil  
How to use RANK function in Excel In Tamil    • How to use RANK function in Excel In Tamil