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

Make Mark-Sheet in Excel

Make simple dynamic mark sheet 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