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

[@sunkissed_01]

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.

[@XxToxicCandyxX1]

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

[@valentinoonuora6021]

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

[@shaukatsamad2510]

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 .....

[@amandalohiser6720]

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!

[@Hugoboss185]

Same here...

[@SibusisoNhlane]

You're the best teacher!! For the first time, I got this formula right!!

[@marioruiz4510]

You save me from a cerebral collapse. Classy.

[@sadmansaquib8804]

I was really struggling with the remittance commission and tax calculation. This video helped me a lot.

[@Flightunamed]

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

[@goingback2505]

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

[@aishwaryapaul1961]

Wow you explained better than my teacher 😭

[@yorelnaturals]

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

[@ferrowkapadia]

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

[@jacobzornu]

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

[@aswinrajk6524]

Today is my exam
This is helpful
Thanks broo

[@hasibulsourov5873]

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

[@emka1888]

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

[@Otaku_Anime699]

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??

[@shrikantshinde4526]

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

[@prabhuvel9307]

How to provide color depends upon the grade?

[@shaukatsamad2510]

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

[@ciscokid6827]

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

[@akhilmaddela8325]

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

[@Rohithgbd]

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

[@NoSupports]

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

[@srabankumar7639]

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.

[@cagayanplasticcenter6485]

how do you set a color for each letter grade?

[@allisonduffus5145]

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

[@kwadzotheblogger]

Can’t believe I’m now watching this. 12yrs ago 😂I was 9 years then.
By the way, learnt a lot from this ❤

[@alanafrazer]

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

[@elliotfps]

Hi why does mine just turns up as false

[@mannynoneya7143]

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

[@bonhidutta1853]

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

[@revhineparol5810]

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

[@q8wq8w]

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

[@sbtmirza329]

Thank you Sir for saving my career 😄😄😄😄

[@WahidhaAsif]

what to write the formula if any student absent

[@RMmazel]

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

[@kazisabbirulislam419]

how can i apply this in large number as a example 0 -- 99; 100 -- 199; .............. 10000 -- 10099

[@khatepanol1865]

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

[@alphalegion1416]

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

[@adamsharaf2009]

thanks dude that really worked for my exam

[@hassenmohammed2535]

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

[@asmaazaki708]

I think you would type it in a cell and make it equals that cell

[@motherlandschoolandcollege9294]

My formula is not working =if(E3>=80,"A+",if(E3>=70,"A",if(E3>=60,"A-",if(E3>=50,"B”,if(E3>=40,"C",if(E3>=33, "D","F")))))) Please help.

[@jillposta9078]

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

[@Hugoboss185]

You make my life easier! Thank you

[@SD12345-]

i love you too

[@MuhammadAbdullahkingAB]

My apologies, there was punctuation mark problem, it really works with even 10 arguments, thanks

[@punnareaythampanhaboth9h914]

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

[@Revsb1]

I get F for all answers, what did I do wrong?

[@hawraalbahrani7948]

thank you this was soo much help for my test

[@philemonbabu3273]

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

[@wahidarowshonjhumur1282]

Excellent . So much useful video....

[@sarahgoodman6410]

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

[@erasmovargas4656]

Excellent tutorial. Thanks for helping me.

[@abdaalzulfiqar2474]

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

[@philemonbabu3273]

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

[@kavuriravindra]

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

[@benarddosier8706]

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

[@traceygrandmor302]

Great video. i love this

[@donnaramirez6188]

Thanks! Your explanation helped a lot!

[@banwatta1890]

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

[@jomeltauza8609]

Very helpful my bro

[@sdcsom8120]

thanks Doctor really you assisted me to this Formula

[@MrSrikumaran]

hassan ali mohamed to

[@philemonbabu3273]

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

[@prakashrao914]

Thanks a lot !! This is as good as a coffee :)

[@MuhammadAbdullahkingAB]

what if someone has 10 arguments, yse I do, but Excel is not supporting it.

[@sumayamohamedhilowle4279]

Thanks this was helpful for my Assigment

[@kamalhassan6854]

This was really helpful. Thank you Sir.

[@iamjohn1802]

A= 90-100
B=80-90??
it think it should be A = 91-100 and B 81-90...

[@PhantomOnPrime]

Bruh he was just giving example

[@ibnuaziz846]

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

[@LorotJunior]

I appreciate I hope I will pass My exams

[@jerseykosh]

helped me so much,, thank you!!

[@aimanhamizan5061]

Thank you, this helps me a lot

[@mondlasuresh6518]

Really useful in studens

[@hildacapacite8622]

Thank you very much. Very informative.

[@nurizzatizainol]

Very useful even for work thank you so much❤

[@samsonshile8299]

the video was helpful, thanks.

[@KozyToast]

Thank you for making this!

[@islandhoney8103]

love these videos

[@theresasutherland3410]

very informative and helpful thank you.

[@divyasoni6183]

nice guidance😊

[@mahambaig7101]

THANKYOU! EXTREMELY GRATEFUL TO YOU!

[@danicanedelkovski5601]

Just what I needed. Thank you!

[@SD12345-]

i love you.

[@waheedbutt3134]

Amazing sir

[@SufianLau]

Just what i need. You rock.

[@extremepacifist8719]

Thank Youuuu! Final Exam=)

[@gabrielmasacupan4476]

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

[@tatskieluague4399]

thank u so much...big help for me

[@derrickmikhail3853]

it was very helpful...i appreciate it

[@animamos6793]

You are the real MVP

[@abdiazizadan76]

Very nice. Thank you bro

[@payelshomerecipe9517]

thank you very much

[@naahidul]

It is pretty much comprehensive..

[@bethxx1058]

I've got a test tomorrow😓😭The formula is longer than a bridge

[@topsealrockers]

thank you so much. very helpful

[@bpd223]

Thanks so much! Great tutorial!

[@msv-learning]

very helpful, thank you!

[@lizardof78]

Thank you for your help!

[@MadaniZakri]

Very helpful thanks

[@cbrowning1989]

Thanks this really helped me alot