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

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

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