Hello friends..!! Aaj hum MS EXCEL me MARK SHEET kaise bnate hai vo btayege Question: -HOW TO MAKE THE MARK SHEET (STEP BY STEP)? § Let’s start -> Step 1:- Open the MS Excel. Step 2:- Make a Data of student. Step 3:-Make the column also Total, Percentage, Grade & Result. Step 4:- Add the Total formula Formula =sum(first no. cell address:end no. cell address ) Step 4:- Add the Precentage formula Formula =total cell address/no. subject ) Step 4:- Add the Grade formula Formula =IF(percentage cell address>85,"A“,IF(percentage cell address>75,"B",IF(percentage cell address>65,"C",IF(percentage cell address>50,"D","F“)))) Step 4:- Add the Result formula Formula =IF(AND(Ist subject no. cell address>33, IInd subject no. cell >33,IIIrd subject no. cell >33),"pass","...
Comments
Post a Comment