How to make student Marksheet in excel Rank for pass students

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=dBtjED8Z2z8

In this excel tutorial video we will learn about how to make student mark sheet in ms excel with result , grade and Rank only for pass students . Below are the steps shown for calculation details:- • To watch Part-I Video: • how to make student marksheet in MS e... • STEP 1: calculate a Percentage column • =H21/ I21*100 • STEP 2: how to calculate a pass/fail column • In this example, if the marks in each subjects is over or equals to 33, then the student has passed the class • Type = if and add the left parenthesis. • Type and and add the left parenthesis. • We click the C21 column in this video. • It is if it is greater than or equals to thirty three ; so, we type greate than sign along with equal to sign 33 . and the same continued till G21 and add the right parenthesis. • if the condition is true, then the student has failed the class. We type Pass in double quotation marks. We type ,Fail . • In this example, we see that Bhola had marks in hindi 30, and he has failed the class. • We'll see that Ram,Shyam,Mohan,Sohan etc.have passed the class • STEP 3: how to calculate a Grade column • STEP 4: how to calculate a Rank column • This was how to add an If-then function to determine Pass versus Fail in Microsoft Excel. If you have any questions or comments • Thanks for Watching • MY SMART COACHING

#############################

New on site