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

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”)))

 

Learn If formula in details Click Here

 

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

 

 

 

 

Click Here to Buy Mark-sheet Maker For Unlimited Entry’s