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.
Type =MIN( then Select Range that entered marks & Close Bracket.
=MIN(E4:E9)
Maximum:
Type =MAX( then Select Range that entered marks & Close Bracket.
Type =MAX( then Select Range that entered marks & Close Bracket.
=MAX(E4:E9)
Average :
Type =MIN( then Select Range that entered marks & Close Bracket.
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
Excel to calculate percentage Normal Format =E10*100/D10