How to create Marksheet in MS Excel with the help of 'IF' & 'IFS' functions | Learning With MHR | English, Hindi & Urdu

How to create Marksheet in MS Excel with help of 'IF' & 'IFS' functions 

In English, Hindi & Urdu 

Same as below then click  on image or watch video:  

Formulae uses in this lecture: 

Total: "=sum(b3:d3)" then fill handle for other cells.

 Percentage: "=E3/300" then similarly, fill handle apply.

Grade Method1 (Use with IF function): "=if(f3>=90%,"A+",if(f3>=80%,"A",if(f3>=70%,"B",if(f3>=60%,"C",if(f3>=50%,"D",if(f3<50%,"Fail"))))))or,
"=if(f3>=90%,"A+",if(f3>=80%,"A",if(f3>=70%,"B",if(f3>=60%,"C",if(f3>=50%,"D","Fail")))))"

Grade Method2 (Use with IFS function): "=ifs(f3>=90%,"A+",f3>=80%,"A",f3>=70%,"B",f3>=60%,"C",f3>=50%,"D",f3<50%,"Fail")"
Note: If you get any problem in these formulae then comment please, I am happy to help you guys.

Watch This Video For Full Concept Of Marksheet

 

Or, Click Here For Tutorial: Marksheet Tutorial