Calculate Grade and Percentage using Nested If in MS Excel,#18

Amaging😊

Your last percentage is 111 is it right??? My formula show 87 can you please explain??? M i right or you??

Sir ji
Sort tarika bataiye Grat nikalne ka

Thank you

Nice

Nice

Thankyou 😲😲

Thanks it helps me alot

Thanx

Pankaj's percentile is wrongly calculated.

Thanks sir, it's so helpful

Thank you very much

You can just copy paste to following code below, I am using this grading interval :

90-100 A+
80-89 A
75-79 A-
70-74 B+
65-69 B
60-64 B-
55-59 C+
50-54 C
47-49 C-
44-46 D+
40-43 D
30-39 E
0-29 F

=IF(Y4>=90,"A+",IF(Y4>=80,"A",IF(Y4>=75,"A-",IF(Y4>=70,"B+",IF(Y4>=65,"B",IF(Y4>=60,"B-",IF(Y4>=55,"C+",IF(Y4>=50,"C",IF(Y4>=47,"C-",IF(Y4>=44,"D+",IF(Y4>=40,"D",IF(Y4>=30,"E",IF(Y4>=0,"F")))))))))))))



Replace your own value for G3, in my case I am using column Y. Thank you and have a good day.

Thnx sir

Bsdk Hindi me bhi bol liya ker

Itani English mat ghad

My also

🙏🙏🙏🙏🙏

हिंदी नी आती क्या

It is not the proper procedure ..... See in 2nd row ... Ram secured 12 mark in math which is fail mark then how he got D grade

Thank sir this correct or wrong!!

Thank you sir

My question is this,
<35 means If student score 20 means he will get D.
I prefer to use > rather than <

Thank you sooo much it is my practical exam on friday and its was soo much help form you thank you soo much

Best channel

thank you so much

Thank you sir that will help me alot

Love the music

Thank you so much I learnt a simple formula to use

I suppose less than or equal to 100 should be used in the last one coz less then 100 will give 100% invalid

Flicka flicka

Sir thanks

marriage and nonmarriage ka sheet bhejo bhai

This helped me out thnx

Himdi main pdha yarr 😕😕

YOUR ACT OF KINDNESS AND SERVICES, SHOW HOW BIG OF HEART YOU HAVE FOR OTHERS. THANKS WE DO APPRECIATE
ANDRIANCRACK
ANDRIANCRACK..

YOUR ACT OF KINDNESS AND SERVICES, SHOW HOW BIG OF HEART YOU HAVE FOR OTHERS. THANKS WE DO APPRECIATE
ANDRIANCRACK
ANDRIANCRACK.

ANDRIANCRACK
ANDRIANCRACK
Finally *the above name * is getting the recommendations and reviews due because he’s beeen massive and genuinely good at what he does

ANDRIANCRACK
ANDRIANCRACK
Finally *the above name * is getting the recommendations and reviews due because he’s beeen massive and genuinely good at what he does

Great! Expend for your tutorial.

thanks

Please sir speak urdu and Hindi.

Nice

Great! I am so happy to learn this from you.
Thank you.

Thank you for teaching, sir.
How about if criteria is between 90-100?
What's the formula, sir?😅

Thank a lot 🤗

Some students absent than how to use formula for absence students

Not understand 🤢🤮🤧😷🤕🤒 fever ho gya

Lots of love sir g
Thanks 👍👍👍