Calculate Grade and Percentage using Nested If in MS Excel,#18
HTML-код
- Опубликовано: 22 авг 2024
- 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-surajdatir.mca@gmail.com
IT Skills With Suraj Datir
#GRADE#PERCENTAGE#EXCEL
thanks it helps me in the practical but still I think percentage is easy to find the grade.😃😃😃
Right
hi sir myself yogeshwari sapkal ,thank you for your video
Your last percentage is 111 is it right??? My formula show 87 can you please explain??? M i right or you??
He is just explaining to make us understand the "Not valid" option.
Lots of love sir g
Thanks 👍👍👍
Nice
Brilliant videos
Thank you
Thankyou 😲😲
Best channel
Amaging😊
My question is this,
rather than
Most knowledgeable video in world
Thanks for this. It's really helpful.
Ur teacher way so great....sir i request to that please made more videos for excel formulas...
Sure
Thanks sir
vey nice sir ji hats off.
Thank u soooo much sir. Your video was very helpful for doing my project......🙏🙏
Thank you sir that will help me alot
Great! I am so happy to learn this from you.
Thank you.
Thank you very much
Thanks it helps me alot
nice tutorial..
Ye cooma konsa hai curly comma ?? Jo A or b or c Py lgaya hai ye kesy lgega comma
Thank you sooo much it is my practical exam on friday and its was soo much help form you thank you soo much
your vidio is very beautifull
Thank a lot...🙏🙏🙏it has helped me a lot
thank you so much
Thanx
Thnx sir
Love the music
Thank you so much ❤🌈
O
This helped me out thnx
thanks
Thank you very much sir. Please make more like this. This videoes helped me in learning.
Thank you so much I learnt a simple formula to use
🙏🙏🙏🙏🙏
Sir thanks
Some students absent than how to use formula for absence students
Teacher give average marks for absent students or result is pending
My also
Thank a lot 🤗
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
Thanks Sir😊😊
When will not valid come?
Thank you for teaching, sir.
How about if criteria is between 90-100?
What's the formula, sir?😅
Video mis interupt us there😛. If student gets marks equal to 100 then??
Here he is only talking about marks less than 100.
Sir plz take english couches
Sure
Thank you very much,,,,, you are my person/guy.
Thankyou so much it was so useful at the last moment 1's again thankyou so much🙂🙂
Thank u sir, it will be helpful in my exams, really thanks
Thanks you sir
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
Do carefully
ʙʜᴀɪ ꜱᴜɴɴ yᴇ ᴩᴀɢᴀʟ ɴᴇ ꜱᴀʙᴋᴏ ᴩᴀɢᴀʟ ʙᴀɴᴀyᴀ ʜᴀɪ ᴛᴜ ᴅᴇᴋʜ
05:58 ᴍᴇ ᴅᴇᴋʜ ʟᴀꜱᴛ ᴍᴇ 3 ʙʀᴀᴄᴋᴇᴛꜱ ʜᴀɪ
ᴀᴜʀ ꜱᴀᴀʟᴀ 1ꜱᴇᴄ ᴍᴇ
06:00 ᴋᴏ 4 ʙʀᴀᴄᴋᴇᴛꜱ ʜᴏ ɢyᴇ
ꜱᴀᴀʟᴀ ʜᴀᴅʜ ʜᴀɪ ʙʜᴀɪ ʙᴏʟᴅᴇᴛᴇ ɴᴀ ᴠɪᴅᴇᴏ ᴍᴇ ᴍɪꜱᴛᴀᴋᴇ ʜᴀɪ ᴄᴜꜱᴛ ᴋᴀʀᴋᴇ ʙᴀꜱꜱ ᴜᴩʟᴏᴀᴅ ᴋᴀʀ ᴅɪyᴀ
ʟᴏɢ ᴩᴀʀᴇꜱʜᴀ ʜᴏʀᴇ ʜᴀɪ ᴠɪᴅᴇᴏ ᴅᴇᴋʜ ᴋᴀʀ
ʜᴀᴅʜ ʜᴀɪ ʙʜᴀɪ
hindi is your offical language the why you are not speakig hindi
English is my teaching language
@@ITSkillswithSurajDatir
🤗
Great! Expend for your tutorial.
Thank sir this correct or wrong!!
I suppose less than or equal to 100 should be used in the last one coz less then 100 will give 100% invalid
Yes video is noy upto marks but still he is getting views and ee are commenting 😂
marriage and nonmarriage ka sheet bhejo bhai
HI PLZ HELP HOW MUCH WILL BE AB ???
Nice job sir
ye criteria kaha likhna hy
Pankaj's percentile is wrongly calculated.
Himdi main pdha yarr 😕😕
Please sir speak urdu and Hindi.
Hindi me bhi bol liya karo sir
Kyu
thak ai boor aa
OMG, thank you so much.
Not understand 🤢🤮🤧😷🤕🤒 fever ho gya
हिंदी नी आती क्या
sulliga
english bolna jaroori ahi bhai ssare in dian hi hai \
Itani English mat ghad
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
YOUR ACT OF KINDNESS AND SERVICES, SHOW HOW BIG OF HEART YOU HAVE FOR OTHERS. THANKS WE DO APPRECIATE
ANDRIANCRACK
ANDRIANCRACK..
Wow, thank you
YOUR ACT OF KINDNESS AND SERVICES, SHOW HOW BIG OF HEART YOU HAVE FOR OTHERS. THANKS WE DO APPRECIATE
ANDRIANCRACK
ANDRIANCRACK.
Nice
Thanks sir, it's so helpful
thank u sir
Thanku Sir
Thank you
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
Nice
Thank you sir
Thank you sir
Thank you sir
Thanks sir
Give me ur uid
Bhai my id is AVIRALBISHT