Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

No matching category found.

No matching Locality found.

Outside India?

Search for topics

How to grade the students when the criteria is given?

Yoga Teacher

Hi Anurag, I hope you have the criteria like below shown Comum A, B, C and now add the following formula in co, umn C to get the grade according to the percentage. Please revert if you have any questions. =IF(B2<=45,"D",IF(B2<=60,"C",IF(B2<=80,"B",IF(B2<=100,"A")))) Column A Column B Column... read more

Hi Anurag, I hope you have the criteria like below shown Comum A, B, C and now add the following formula in co, umn C to get the grade according to the percentage. Please revert if you have any questions. =IF(B2<=45,"D",IF(B2<=60,"C",IF(B2<=80,"B",IF(B2<=100,"A")))) Column A Column B Column C Student Names Percentage Grade Ram 60 C Suman 80 B Leela 95 A Joe 70 B
Regards,
Nagamani

Hi Anurag, You can use the "=Rank" formula or you can use the nested if condition

Hi Anurag, there are various ways to do it in excel. either you can create the grade syatem and apply VLOOKUP or you can write a formula with nested if to get the desired output.

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Related Lessons

Learning Pivot Table Part-1
You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...

Kaustubh Chavan | 01/12/2018

Looking for Microsoft Excel Training classes?

Find best Microsoft Excel Training classes in your locality on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Find Best Microsoft Excel Training classes?

Find Now »

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more