Make Mark-Sheet in Excel Using Formula Min, Max, Average, Percentage, IF with Example

by

Make Mark-Sheet in Excel

Make simple dynamic mark sheet in excel

Creating a marksheet in Excel is very easy. Using Excel formula, we can create marksheets in advance and in less time. You need to learn some simple formulas to create a marksheet in Excel.

Mark sheet Calculation make simple .
use formula Min, Max, Average, Percentage, IF
IF              : =IF(E4<35,”F”,IF(E4<60,”C”,IF(E4<80,”B”,”A”)))
 
 
Minimum:
Type =MIN(      then Select Range that entered marks & Close Bracket.

  =MIN(E4:E9)

 
Maximum: 
Type =MAX(      then Select Range that entered marks & Close Bracket.

=MAX(E4:E9)

 
Average    :
Type =MIN(      then Select Range that entered marks & Close Bracket.

 =AVERAGE(E4:E9)

 
Excel to calculate percentage : =E10/D10  ( Cell format must be Percentage )  or 
Excel to calculate percentage Normal Format  =E10*100/D10
 
 

Click Here to Download workbook

Leave a Comment