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

In this tutorial we will see how you can represent grade in marksheet using Nested IF Function in Excel.
Following is the syntax of Nested IF statement.
IF(cond,"TRUE",if(cond,"TRUE",if(cond,"TRUE","FALSE"....)))
Thanks for watching
[e-mail]
IT Skills With Suraj Datir
#GRADE#PERCENTAGE#EXCEL

[@CRAZZYGAMERS5723CGgamers]

thanks it helps me in the practical but still I think percentage is easy to find the grade.😃😃😃

[@jabeenfayyaz5950]

Right

[@marotisapkal3915]

hi sir myself yogeshwari sapkal ,thank you for your video

[@user-me1ni7qk3g]

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

[@padmak6316]

He is just explaining to make us understand the "Not valid" option.

[@Exponential-Trader.]

Lots of love sir g
Thanks 👍👍👍

[@vp-garden]

Nice

[@sunilkhond6308]

Brilliant videos

[@onlineearningtrickstutoria7171]

Thank you

[@Shrashti7770]

Thankyou 😲😲

[@devanshduggal9024]

Best channel

[@Ayyaz_Tanwar]

Amaging😊

[@ahmedmohamud1619]

My question is this,
rather than

[@raosahebwadkile2810]

Most knowledgeable video in world

[@marie-qw2tu]

Thanks for this. It's really helpful.

[@amnasohail3039]

Ur teacher way so great....sir i request to that please made more videos for excel formulas...

[@ITSkillswithSurajDatir]

Sure

[@NaseemKhan-ed6bi]

Thanks sir

[@rishavkumar1845]

vey nice sir ji hats off.

[@chithra7380]

Thank u soooo much sir. Your video was very helpful for doing my project......🙏🙏

[@nigarsultana6512]

Thank you sir that will help me alot

[@bapubapu9376]

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

[@emmanuelhakizimana1998]

Thank you very much

[@havefun3260]

Thanks it helps me alot

[@komolst1514]

nice tutorial..

[@anumsehar7703]

Ye cooma konsa hai curly comma ?? Jo A or b or c Py lgaya hai ye kesy lgega comma

[@nissyjaison2146]

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

[@waleedahmad2315]

your vidio is very beautifull

[@smita1888]

Thank a lot...🙏🙏🙏it has helped me a lot

[@anupamhazarika8133]

thank you so much

[@englishclasses1665]

Thanx

[@ruchikasharma8302]

Thnx sir

[@gmcoy213]

Love the music

[@soumyasingh2004]

Thank you so much ❤🌈

[@kdevil9510]

O

[@navtashsingh4412]

This helped me out thnx

[@carryinvlog7753]

thanks

[@susmitaghosh4651]

Thank you very much sir. Please make more like this. This videoes helped me in learning.

[@danielakoyleek3757]

Thank you so much I learnt a simple formula to use

[@srisaitamil]

🙏🙏🙏🙏🙏

[@krishnavishwakarma2920]

Sir thanks

[@sandeeppatil2959]

Some students absent than how to use formula for absence students

[@ITSkillswithSurajDatir]

Teacher give average marks for absent students or result is pending

[@hasnatezazahamed1715]

My also

[@akritikharel3605]

Thank a lot 🤗

[@prasanjitnath4592]

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

[@mpsainijaipur]

Thanks Sir😊😊

[@sabitachakma8422]

When will not valid come?

[@user-vx5hp2fj2s]

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

[@abhinavsaxena7419]

Video mis interupt us there😛. If student gets marks equal to 100 then??
Here he is only talking about marks less than 100.

[@PoornaPrajnaVidyaniketanaBHSHE]

[@ramkoirala2766]

Sir plz take english couches

[@ITSkillswithSurajDatir]

Sure

[@gracewanjiru3218]

Thank you very much,,,,, you are my person/guy.

[@joice8647]

Thankyou so much it was so useful at the last moment 1's again thankyou so much🙂🙂

[@shalakaborhade4515]

Thank u sir, it will be helpful in my exams, really thanks

[@amitmaithani2282]

Thanks you sir

[@shaheenshaikh7604]

I have written exactly like urs but still it is showing If(logical_test,[value_if_true],[value_if_false] what to do plz help

[@ITSkillswithSurajDatir]

Do carefully

[@shaiksameerbond3708]

ʙʜᴀɪ ꜱᴜɴɴ yᴇ ᴩᴀɢᴀʟ ɴᴇ ꜱᴀʙᴋᴏ ᴩᴀɢᴀʟ ʙᴀɴᴀyᴀ ʜᴀɪ ᴛᴜ ᴅᴇᴋʜ
05:58 ᴍᴇ ᴅᴇᴋʜ ʟᴀꜱᴛ ᴍᴇ 3 ʙʀᴀᴄᴋᴇᴛꜱ ʜᴀɪ
ᴀᴜʀ ꜱᴀᴀʟᴀ 1ꜱᴇᴄ ᴍᴇ
06:00 ᴋᴏ 4 ʙʀᴀᴄᴋᴇᴛꜱ ʜᴏ ɢyᴇ
ꜱᴀᴀʟᴀ ʜᴀᴅʜ ʜᴀɪ ʙʜᴀɪ ʙᴏʟᴅᴇᴛᴇ ɴᴀ ᴠɪᴅᴇᴏ ᴍᴇ ᴍɪꜱᴛᴀᴋᴇ ʜᴀɪ ᴄᴜꜱᴛ ᴋᴀʀᴋᴇ ʙᴀꜱꜱ ᴜᴩʟᴏᴀᴅ ᴋᴀʀ ᴅɪyᴀ
ʟᴏɢ ᴩᴀʀᴇꜱʜᴀ ʜᴏʀᴇ ʜᴀɪ ᴠɪᴅᴇᴏ ᴅᴇᴋʜ ᴋᴀʀ
ʜᴀᴅʜ ʜᴀɪ ʙʜᴀɪ

[@sadeedglimpserecords]

hindi is your offical language the why you are not speakig hindi

[@ITSkillswithSurajDatir]

English is my teaching language

[@ritutiwari9778]

@@ITSkillswithSurajDatir
🤗

[@md.ziaurrahman9146]

Great! Expend for your tutorial.

[@rheajobin06]

Thank sir this correct or wrong!!

[@danielakoyleek3757]

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

[@abhinavsaxena7419]

Yes video is noy upto marks but still he is getting views and ee are commenting 😂

[@krishnavishwakarma2920]

marriage and nonmarriage ka sheet bhejo bhai

[@itzifraaa8808]

HI PLZ HELP HOW MUCH WILL BE AB ???

[@rajeshganvir8013]

Nice job sir

[@arsalanahmed5338]

ye criteria kaha likhna hy

[@BlackMambaInland]

Pankaj's percentile is wrongly calculated.

[@rishabhrawat3090]

Himdi main pdha yarr 😕😕

[@salehrehman7578]

Please sir speak urdu and Hindi.

[@amanmaurya101]

Hindi me bhi bol liya karo sir

[@amitmaithani2282]

Kyu

[@sadeedglimpserecords]

thak ai boor aa

[@lukakavcic6154]

OMG, thank you so much.

[@eshikaagarwalacademy1169]

Not understand 🤢🤮🤧😷🤕🤒 fever ho gya

[@ujjvalsaklye1306]

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

[@madhubabu2597]

sulliga

[@vishanshukumar5262]

english bolna jaroori ahi bhai ssare in dian hi hai \

[@wwedabingclub.9206]

Itani English mat ghad

[@adamusarki2067]

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

[@andriancrack4049]

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

[@ITSkillswithSurajDatir]

Wow, thank you

[@andriancrack4049]

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

[@syedalihussani3555]

Nice

[@arujampa1425]

Thanks sir, it's so helpful

[@rukminigharjale4687]

thank u sir

[@devanshsadavarte1148]

Thanku Sir

[@gregnikhil1079]

Thank you

[@adamusarki2067]

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

[@TheVidi18]

Nice

[@Balsangeet]

Thank you sir

[@BIT_IndhujaaS]

Thank you sir

[@atifrajput2662]

Thank you sir

[@terabap1815]

Thanks sir

[@yashkevlog9539]

Give me ur uid

[@KalpvrikshVatika]

Bhai my id is AVIRALBISHT