How to use the IF function in Excel

Learn how to use the IF function in Microsoft Excel. This tutorial demonstrates how to use Excel IF with an easy to follow example. We also point out one of the most common mistakes made when using the IF function.
IF Function (and sample data):
www.techonthen...
Excel Tutorials:
www.techonthen...
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: www.techonthen...
or follow us on:
Facebook: / techonthenetcom
Twitter: / tech_on_the_net
Pinterest: / techonthenetcom

[@rhetth.708]

Holy crap, this is the easiest explanation I've ever seen on writing "IF" functions. Thanks!

[@laurahano7448]

Finally! Took me 10 minutes of experimenting to make this work for my needs. This will save me so many hours of work in the future. Thank you!

[@RitaMidwest]

You were the only one who explained it well. thank you.

[@oneaviatiorandminecraft]

Very helpful for online class! Thank you so much.

[@stevelong9328]

you have helped me a bunch, it took me a while to know how to phrase my search before I could gather your info, thank you kindly.

[@roger2bro]

thank you so much, short and easy to follow with my limited programming experience!

[@alexdixon8077]

Thank you, I was able to do a very long if formula to display results for over 2000 orders!

[@Mano-z7t]

I have never seen an excel video this simple. Wow ..

[@Gold26502]

so short and straight to the point, thankyou :D

[@awesomepig6400]

thank you for the tutorial

[@femz6438]

Brilliant and to the point, exactly what I needed for a work problem I was struggling with. Thank You!!!😊

[@snydahyuanangi-xb6kb]

YOU ARE THE BEST ONE OUT OF ENTIRE UA-cam....THANKS A LOT

[@jobogutu9630]

cant believe it was this simple. I must subscribe for more. Many THANKS

[@yaokuanhuang4816]

Thank you! This helps so much! Ive been doing CAT and saw this function in my textbook. I got so confused about it and used this video.

[@wayando]

Thanks alot. Am using Excel for keeping accounts, your lesson always makes me improve my system.

[@sitambarammurugiah9563]

Really simplified and easy to capture

[@MauricioSedano-m8m]

Thank you so much for creating this content.

[@bdeggg]

You don't understand how much you helped me tanks so much

[@hendmohamed851]

Short and to the point ! Great Explanation , just wish that there were another video explaining adding both false and true conditions and another video explaining "IFS" formula

[@Techonthenetcom]

Thank you! Here is the video explaining the "IFS" formula: ua-cam.com/video/pdJ_OiTqzT4/v-deo.html

[@STEPHENBOUNDS-k7p]

one word simple... awesome thank you

[@sammykewa7352]

Thank you for sharing this helpful information

[@Dendosa]

Great video. saved me tonnes of time!!

[@Waytoepicofficial]

Thanks for help out this formula

[@MuhammadMurtaza-f3n]

Came here for my paper which is tommorow really easy😅

[@omphemetsematshidiso4984]

Mine is in an hour😐

[@red34x52]

Came here cause a kid asked me how to use it,gave a lame excuse bought my self some time

[@hellishsnake]

For the people having problems with this funcion, it was appearing a error massage in excel so I changed the " , " to " ; " and it worked fine, I was getting mad before solving it

[@bangiovi]

I was about to smash computer, its like 10th tutorial with same comma thing.

[@danielferdinandfong3729]

Ty

[@Liberty_Freedom_Brotherhood]

Must have been an older version of Excel in the tutorial, thanks for figuring it out and posting to help others!

[@sindiswangwenya4729]

Thanks so much

[@kio3285]

ty

[@jasminr.verano7758]

Thank you, very precise video

[@kayleighskitchen646]

Thank you , This was very helpful.

[@athenadixon2110]

This really helped me out! Thank you!

[@SuTUM94]

Helpful for me. Thanks.

[@Alanna_isSLAY]

Computer test today that is why I’m here lol 😂

[@richierich2390]

Thank You so very helpful..

[@tameikanewell2808]

Very helpful. Thank you. Blessings!

[@hafsagul6187]

My test was so horrible yesterday
And he gave me second chance to get 70% so here I am

[@alexterra3467]

this saved my life , wonderful video and explanation.

[@sagnikmukherjee225]

Thank you very helpfull video..

[@virginia2095]

Omg thank you so much. I was so frustrated

[@srichakkravarmas]

Very useful teach thanks

[@sumaiyaansari9968]

I'm writing CAT tomorrow. Had to see this. Thank you✨

[@a.p.7505]

Finally, I Understood !! THANK YOU! 6.18.2022

[@engna2403]

thank u this was helpful

[@RaDi-n7z]

Extremely helpful videos! Thank you so much

[@ugottaluvutube]

Thank you!

[@62-anikamubasshira54]

thanks for such a awesome tutorial

[@nardia649]

came here to review for the observation class later 🥰✨ Thank you very much for this.

[@demensclay6419]

This is the way to explain things

[@wildwestgunslinger6995]

Simple and easy to understand thanks

[@acedelacruz9680]

Thank you very much this is very helpful

[@hadafismail5750]

Thank you

[@zahidahsafardi9319]

it is very helpful, thank you for your explanation

[@Techonthenetcom]

Glad to hear that!

[@frilink]

THANK YOU.........

[@jalehhajiaboutorab7442]

thanks very helpful

[@DanishImran-ut6ge]

great info

[@amirjutt0]

Im in my lab Right now and can't see what the tutor is teaching...so im here

[@ZlatkaGocheva]

Thank you very much!

[@tanisheamiller921]

❤thank you so much

[@emmanuelkatyamba1561]

this is nice i understood the If function without any challenge thanks.

[@Techonthenetcom]

Great!

[@nfl9851]

oooh so simple , thank you mam, they way teaching is amazing👍🏻👍🏻

[@edwarddizengoff8414]

Great video very helpful! Thank you so much

[@hafeezulhaq9920]

Informative

[@harrylamford3637]

Very helpful

[@jhuanivybrandino6412]

VERY HELPFUL AND DIRECT TO THE POINT! THAAANKS!

[@TheADD.]

nice explain

[@ipnnemkhan]

Thanks I have done

[@jeevanjoshi427]

Brilliant

[@dailymoodz5799]

Thanks alot

[@lkhagvasurendechinlkhundev410]

Very helpful! Thank you!

[@samiullahsahil4734]

thanks for explaining

[@yousafzplayz]

thanks

[@syarifyt7757]

Brief and well explained.

[@jimboslice1095]

great video i trade stonks with this

[@air81235]

Tysm🙏

[@forallcurso4131]

Thanks. I have just forgotten..thanks for reminding me.

[@cedricjoshdantes3021]

Thank you.

[@MinhNguyen-mn3gq]

thanks!

[@ubadamahmood1482]

thank you!!!

[@Fayroll5]

Tomorrows my exam, wish me luck 🤞

[@Techonthenetcom]

Good luck! :)

[@rons.6683]

Thanks, great vid!

[@yeslamk2846]

thank you for your explanation, i hope get more explain about the function of ", # ' &

[@Wheee7245]

ok. is there a parameter to recolor a row a certain color? =(E2

[@ksdnsdkumar1375]

Thanks, but it would be good to include return value instead of leaving empty otherwise people won't know where to include return value in the IF syntax.

[@johnsknows3135]

very clear and concise

[@zikrinazim8562]

U are such a hero.

[@anthonyyung3387]

Great! Many thanks for your teaching.

[@suzanrai3318]

helpfull

[@Aydee2020]

Short and perfect explanation :)

[@pengyipeng1661]

Thanks! good job

[@danielcudjoe9544]

GOOD VIDEO

[@Techonthenetcom]

Thank you!

[@dickyrock1]

Great, thanks

[@khansvirtualdiary]

old tutorial excel very helpful

[@pandeynikhilone]

IN short THANKS !!!

[@bashiirmuuminxassan223]

Keep going

[@jamespaul4618]

2:55 how to return a blank cell. Use "" "" no spaces.

[@xblazexonex]

Instead of adding a custom word, such as reorder, could the result be the information from another cell in another sheet in the workgroup?

[@shah00le]

i love u

[@draganvlavojinovic766]

yaaaaaaa baby

[@aftabmahmood1625]

What if the quantity is 7 or below?

[@NA-tu7nt]

it will say "reorder"
anything below 10, will say reorder.

[@fletchers191]

Can you use the if function to automatically go on to another cell value once the original cell is now zero??

[@felipemartinez8464]

My example is look like this =IF(c3

[@celestineathenadelvalle6833]

You should make your formula like this
=if(c3

[@cliftonolaivar6358]

@Felipe Martinez you must have value on your c3

[@yousafzplayz]

vey noiceec

[@EliseFrost]

when you copy them from D3 to D5, how did you get the formula to change from B3 to B5? ie how did you get it to not be constantly B2?

[@orlantabuadajr90]

" How did you get the formula to change from B3 to B5? ie how did you get it to not be constantly B2?" - Answer: it's simple when you want to use the "IF" function, you really need to click on what column do you want to test your data. Since the data was found on the column "B" where you want to know the result base on the "Quantity", it will always follow that the formula will be on "B2". Why it's not constant to be "B2"? because when you drag it downward, the formula automatically follows on what column does the data that you want to check. Hope this help you.

[@jobogutu9630]

excel is programmed to work like that for any formula you copy paste to other cells

[@jobogutu9630]

it comes automatically when u copy paste a formula