MS Excel, the "IF" Function, & Letter Grades 

You're the only one who was able to help me with this, and explain it properly. Thank you.

THANK YOU SO MUCH OMG I SPENT 3 MONTHS ASKING MY TEACHER THIS AND NOW I FOUND YOUR VIDEO WHERE YOU LITERALLY EXPLAINED IT IN 6 MINS.

This short tutorial just saved me 2 hours of manual error-filled grade allocation. Thanks a million

I appreciates a person who doesn't drag a video out lol Thank You so much!!!

Thank you, thank you, THANK YOU! You just saved me hours of eye-twitching, nerve-inducing, anxiety-creating manual input. You rock. I can't believe I didn't know these Boolean functions existed. Your tutorial made it easy-peasy! Thanks again!

You save me from a cerebral collapse. Classy.

I've been scratching my head all night trying to figure this out. This really helped. Thanks!

Thank u for this video tutorial. I appreciate it more than I thought before

OMG! THANK YOU SO MUCH!! IT WORKED!! I WAS DOING DIFFERENT VALUES FOR SOMETHING BUT THIS FORMULA WORKED GREAT!! THANK YOU SIR!!

Thanks bro it was very easy to learn and u saved my semester 😂😂

This is the first time that i feel so easy to learn becx v can see very clearly it is very bright, thnx I have learned much than the others..... in future pls teach us more n more to better way .....

Thank you, I only needed a quick refresher and this was perfect :)

Thanks. So very helpful. This just revolutionized my excel gradebook.

i wrote so many ifs but this helped a lot, thank u

thanks dude that really worked for my exam

thanks, You made my day.

I couldn't thank you enough for this!

THANKS A LOT. THIS WAS VERY HELPUL FOR ME TO LEARN LOGICAL OPERATION IN EXCEL

Today is my exam This is helpful Thanks broo

Thanks a lot man, I spent the whole day but couldn't find the solutions.

Just what I needed. Thank you!

Great video. i love this

Thank you...but i want yo color the cells according to the grade itself..i.e. A+, B-, C and so...using conditional formatting...can you help me with that??

Thanks! Your explanation helped a lot!

thank you so much. very helpful

Excellent tutorial. Thanks for helping me.

how to give to fromula for exam if grade is A then 3 if b is then 2

Thanks so much! Great tutorial!

Thanks bro u saved my life I have exam tomorrow I forgot how to find grade thanks

Old video, but very helpful till today, thanks a lot!!

thank you so much!! it a very big help especially us kinder teachers thats making a letter grade.

superrrr....information and it used for me alot and thank you so......much. "HAVE A BLESSED DAY TO YOU FOREVER...."

You made my day, thank you very much for the help

It’s 2019 but still very helpful thank you so much

What if I want to use a letter that represents a specific value into my spreadsheet? Will that be possible?

Just what i need. You rock.

This was really helpful. Thank you Sir.

Thank you very much. I’m really appreciated with this video.

This was great!!! THANK YOU!!!!

thank you very much .u make me proud.......

Wow.. Great help in computing my students grade.. Thanks a lot

Super information and i liked it alot and it used for me alot. Thank you so.....much...! HAVE A BLESSED DAY TO YOU FOREVER....:)

Thanks this really helped me alot

Thanks a lot. It really helps.

Simply superrrrrrrrrr.........information and thank you so.....much.

it was very helpful...i appreciate it

THANK YOU SO MUCH!!! I AM ALWAYS GETTING CONFUSED WITH THE IF FUNCTION. LOL.

Sir, can you explain me the reverse one, i.e. if A grade then the mark is 90 to 100, if B grade, then 80 to 90..... Means grade is given and I want to define range of marks for that grade.

Thank you for making this!

Very useful even for work thank you so much❤

What if you want the person's name to be repeated if it is true? That is difficult, I have been struggling with that? If true, repeat their first name for instance

thank you this was soo much help for my test

You make my life easier! Thank you

You are the real MVP

Thank you very much. Very informative.

love these videos

very informative and helpful thank you.

Thank you I was really stuck but now i know what i have to do

Thanks for the help

how do you set a color for each letter grade?

Thank you, this helps me a lot

THANK YOU VERY VERY HELPFULL!!!!!! :

thank you very much

How can we change the colors according to their grade value?

thanks Doctor really you assisted me to this Formula

How to make reverse of it. I need to get the grade from the range. If A is 70-80 & B is 60-70 So if I enter A i need it to show as 70-80 please help me

How u get h2 ,pls explain , there is very difficult to find the formula how u get these formulas, pls explain , that v can use ourself these formulas

THANKYOU! EXTREMELY GRATEFUL TO YOU!

it didn help me.. mine doesn seem to work :/ i tried the formula but its not working

Thank you for your help!

YOU ARE A LIFE SAVER

Thank you Sir for saving my career 😄😄😄😄

Thanks this was helpful for my Assigment

How to provide color depends upon the grade?

Very helpful my bro

very helpful, thank you!

Great video!!!

Thank you very much !

Excellent . So much useful video....

For 2016 excel i tried it , but it works only by replacing , with ;

Thank you! :)

thank u so much...big help for me

wat if the test and the paper hade different gradebook weight? thats my situation

the video was helpful, thanks.

thanks this has helped.

Hi why does mine just turns up as false

Thanks a lot and god bless you.

thanq so much sir,

thanks man for this i got A ^^

thank you very simple to use

Thanks, it is very helpful. thanks for sharing....

i love you a lot . God Bless You.

Great video. i love this please, see the info under

thanks alot man.

Very nice. Thank you bro

THANK YOU VERY MUCH

Thank Youuuu! Final Exam=)

BRILLIANT

Thank You So Much!

It won't let me insert A+ grades in the if formula...please help