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

preview_player
Показать описание
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
IT Skills With Suraj Datir
#GRADE#PERCENTAGE#EXCEL
Рекомендации по теме
Комментарии
Автор

hi sir myself yogeshwari sapkal, thank you for your video

marotisapkal
Автор

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

CRAZZYGAMERSCGgamers
Автор

Thanks for this. It's really helpful.

marie-qwtu
Автор

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

meniqkg
Автор

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

amnasohail
Автор

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

chithra
Автор

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

smita
Автор

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

bapubapu
Автор

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

ahmedmohamud
Автор

Thank you so much I learnt a simple formula to use

danielakoyleek
Автор

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

susmitaghosh
Автор

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

nissyjaison
Автор

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

joice
Автор

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

anumsehar
Автор

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

shalakaborhade