Excel Basics #22: IF function formula made easy!

[@excelisfun]

You have to put text in double quotes, like: =IF(J1>=620,"Unhealthy","Healthy") The video illustrates the concept of Double Quotes for text in the "In Balance" example.

[@excelisfun]

Dear Obee7, I am glad that the videos are useful! I don't have any MS Access videos. --excelisfun

[@excelisfun]

I am glad that you liked the videos!

[@excelisfun]

You are welcome!

[@excelisfun]

I am glad you liked the videos!

[@9811023360]

A big namste from India. I took few days off the work and now spending time brushing up my excel skills and I must say, all these videos have been of GREAT help!! The best thing is you can download the workbooks on which you are giving the examples on!! It makes learning very nice!!! It's simply incredible!!!

[@excelisfun]

I am glad that these help! Remember to rate all videos 5 stars!!

[@excelisfun]

You are welcome!!

[@Marc0427]

I don't normally leave comments, but this was a GREAT video. Thank you sir.

[@excelisfun]

I am glad that the videos help!

[@excelisfun]

I am glad that you like it!

[@linglingjin]

I can't believe that excel could be that easy until I watched your excel video. you make my lift easier. Thank you so much !

[@excelisfun]

I am glad that you like the videos!

[@excelisfun]

What minute are you referring to in the video?

[@excelisfun]

1) Highlight range 2) Alt + D + L (opens data validation dialog box) 3) In Allow textbox select Decimal 4) Enter Min and Max values 5) Click OK

[@rjulyanto]

boy... glad I found you & your easy to follow tutorials... very, very, very helpful..... thank you and stay blessed.... best regards from Bali, Indonesia...

[@excelisfun]

Just a guy having fun with Excel! I am glad that the videos are useful.

[@excelisfun]

I am glad that the videos helped!

[@excelisfun]

Dear maxandbrener, You are welcome for everything! --excelisfun

[@excelisfun]

@AmazingEvents1 , Glad you like it!

[@excelisfun]

@kjhmario , I am glad that it helped!

[@excelisfun]

Without more detail about your setup, I am not sure. But maybe, if Date-Time in A1, maybe something like this: =IF(INT(A1)=DATE(2011,1,4),value_if_true,value_if_false)

[@excelisfun]

I am glad that video helps!

[@excelisfun]

I am glad that you like the video!

[@leocosmosroy]

U R A GOOD TEACHER...AND THE CLASS IS SO SIMPLE TO UNDERSTAND

[@islamiclearner8809]

This video was so fun to watch because you made very interesting. You absolutely sound like a commentator that was big part of it. Great job, great video!. Thanks.

[@excelisfun]

EXCELlent!!! I am glad that you like them!

[@excelisfun]

Thanks! I may not be your teacher then, but now you can watch all these videos!!!

[@NatLili1]

I start a new job tomorrow that requires heavy excel knowledge and I have been learning from your channel for the past 2 weeks. Excel has never been more fun. Thank you for this!!!!!!

[@excelisfun]

You are welcome! Thanks for your Sub and Thumbs Up on each video : )

[@excutivesecretary4141]

hi

[@aprilwinlian]

I totally agree with you..I learn much more here than from my lazy lecturer..

[@excelisfun]

I am glad it helps!

[@excelisfun]

You are welcome! What is IGCSE?

[@Dynamic1809]

you've got my biggest and sincerest gratitude from me mate. an absolute life saver that's for sure.

[@excelisfun]

Dear electricwave, I am glad that there are useful! --excelisfun

[@excelisfun]

Glad the video helps!

[@descendantsoftormaepa]

I can understand your lesson a lot better than my teacher;Thank you!

[@excelisfun]

I am glad that it helped!

[@excelisfun]

You are welcome! If you wnat check out the Basic Series from #1 to #23 and you will get all the basics of Excel!

[@excelisfun]

I am glad it helped!

[@excelisfun]

Maybe this: =IF(A1>=DAY(B1),"not delay","Delay") I think this would work better, though: =IF(A1>DAY(B1),"Past Due","Not Past Due")

[@deathdude333]

Much better than my IPT teacher lol, you can actually keep people engaged.

[@excelisfun]

Dear XUltra00, I am glad that the videos are helpful. --excelisfun

[@excelisfun]

This sort of formatting mistake happens all the time to people. The point of this was to see that formatting can hide decimals, but the formula will always find that mistake!

[@bullygirlxx]

Great - helpful and humourous - and I got the IF Function for the first time - thanks.xx

[@tyeezee]

my oh my, you are an excellent teacher. thumbs up for you!

[@excelisfun]

Try the link now and see if it works. If it is not, please let me know.

[@excelisfun]

I am not sure what you mean, but I hope the video was helpful!

[@excelisfun]

I do not understand your question. Can you re-state it.

[@prahee4suman]

this is an outstanding video and u r an exceptional Teacher

[@excelisfun]

Cool! I am glad that it helped!

[@tomgarify]

Great video! Thanks a lot from the UK!

[@excelisfun]

Use Currency Number Formatting to format the cell before you type. See earlier videos in this Excel Basics Series.

[@moisesramos6746]

You're great, man. These tutorials really helped

[@MistyBishop1974]

Thank you for making this easy to understand!

[@excelisfun]

You are welcome!

[@jimmay1127]

Misty Bishop .

[@manrajabi]

i downloaded your classes, so many thanks

[@jodavis1950]

Thank you for your clear and understandable explanations. I used the Function Argument Box and I didn't have to manually type in the " and so on (hope this was ok). My understanding of the Logical Test was way off! Even the value_if_true, etc., had me confused. Not now! You helped me understand the purpose of the Logical Test and the IF Function. I now not only understand "how" to do a step, but also the "why" I should do it. This knowledge makes a world of difference when you know the "whys". I am a Subscriber!

[@excelisfun]

I do not do consulting work. The best place to ask Excel questions (they do not review people's homework, though) is: mrexcel..com/forum

[@excelisfun]

It is #22. I'll have to add an annotation. Thanks for the heads up!

[@excelisfun]

In cell C1 Try: =IF(A1

[@hisham2553]

great man, great video, and great file to download, I don't know why would someone dislike this video ?????? All the best to you !!! Thank you

[@excelisfun]

You are welcome, H I S H A M !!!!

[@muhammadtaqi1494]

Well explained the IF function. May you have blessings from God.

[@excelisfun]

I am glad that the video helps : )

[@R18matt]

Thank you, Straight to the point and well explained.

[@excelisfun]

Glad you like it, Matt!!!

[@naftitch]

mate, this was awesome and really easy to follow. I was struggling to get the IF formula to work with words and now i know why :) much appreciated

[@khateebsair2741]

Such a lovely way to make other understand. specially that part when you added .01 and at first we didn't even notice!

[@Obee7]

hi Boss 1st of all i wana thank u 4 da very knowledgeable videos its gr8 help for me n i also wana know that do u have MS ACCESS 2007 videos also plz do reply

[@chriskuritjinga3651]

Thank you so much for your help , your tutorials helped me so much . keep up the great work , your videos are simple and they make more sense.

[@queryhsje7514]

Hi, thanks for the video. I had an experience with an equal function where I got a FALSE answer even though they have the same number, like $ 152 and $152, when I build the function =A2=B2 (for example), they gave a FALSE result, do you know why, and how to solve the problem if the data set are large, thanks.

[@aman1245singh]

That 39.01 trick was a good one, lol. I had to look twice to figure out what you had done to retrieve a not in balance answer in the tab. But as always thanks for the videos and God bless you :)

[@truthtolight8188]

I can't find this worksheet under your excelbasics catergory. Can you please let me know how to get it? Thank you.

[@josephchibor4591]

Hello, please i couldn't quite find where i can get the sheet from so i can follow along, i searched but i don't think it's still there. your teachings have been really helpful to me. if i could download the sheets that would be great. Thank you very much.

[@excelisfun]

The link below the video is working.

[@excelisfun]

Here is link: people.highline.edu/mgirvin/KZbinExcelIsFun/ExcelBasics.xls

[@excelisfun]

You can try this link also: excelisfun.net/files/ExcelBasics.xls

[@gbrickcommercialre]

Excellent instruction, and I like your style. Thanks for this!

[@excelisfun]

You are welcome for thet, annette_b!!! Thanks for your support with your comment, Thumbs Up and Sub : )

[@kylesmith6144]

It is really interesting to see just how much boolean logic appears in computational logic. I didn't think boolean was that big of a deal when I was originally learning about it. But the more I look around with computer science, the more I see it everywhere. Granted, this is true for programming in general so it is understandable. But still.

[@amazon5665]

Million thanks dude very easy to understand

[@mattromano83]

you're the real MVP

[@kdssi648]

quick, simple, fantastic not like during school lesson

[@truthtolight8188]

Thank you! Your lessons are fantastic! You are a great teacher!

[@excelisfun]

You are welcome!

[@truthtolight8188]

Thank you very much for the info. I found it!

[@excelisfun]

You are weclome!

[@excelisfun]

Don't use IF, use VLOOKUP. Serach KZbin for "excelisfun", then click on the link to go to my channel, then click on the link for the playlist that says "Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun " That video will show how to find the playlists all about VLOOKUP for grades - I have about 5 different videos for five different grading situations.

[@excelisfun]

I do not understand your question. I do not understand when you say " want the day to tally not the month and year"

[@lindar6569]

Thank you so much for this video, very easy and helpful to understand how to start using the IF formula.

[@excelisfun]

Glad it helps! Thanks for the support, Linda!!!

[@monsoongift]

You are great man, many thanks to this channel :)

[@excelisfun]

You are welcome!

[@qasquence4817]

VERY HELPFUL VIDEO THANK YOU! But i need little help from you. I'm having a bit problem with this IF function but in other case. My case is i have to use that IF function to show "grade" for students. I mean i have 4 elements(A,B,C,D). im so confused how to use that. Please contact me!

[@excelisfun]

Watch this video: youtube[dot]com/excelisfun It shows how to find all 1500 Excel videos that i have created and it shows how to find the playlists of videos for certain topics.

[@excelisfun]

I have many. Serach for this Playlist title: Various Excel Separate Text (like First Last Names) Tricks

[@paulsinclair3753]

Does anyone know why the "Your Bonus" formula wouldn't work in OpenOffice Calc? I typed the EXACT same thing in my b6, and b7 cells (3:54). B6 says "TRUE" as expected, but b7 returns "err:508" instead of either $500, or $0.00. I realize these are two different programs, but OpenOffice software pretty closely matches Microsoft Office.

[@josephparis007]

Thanks for the great work shared with us, it's very helpful.

[@excelisfun]

You are welcome, Chen!!!!

[@pHaZe017]

thanks a lot for the video.!! Just saved me an hour of work

[@excelisfun]

Glad the video helped!

[@rande884]

You are an awesome teacher... Thanks.. This helped a lot... :)

[@coffeeot7_zz]

Is that possible to make same value by using if function?

[@issaki0a]

thanks a lot ExcellsFun this is amaizing

[@andreakazmiersk163]

Thank you for this!!! I had a project I was flying through and once I had to put these "words" in, I hit a brick wall. Your video helped me in 5 minutes after I tried about 30 different ways for 40 minutes.

[@excelisfun]

You are welcome, Andrea!!!

[@BlackmetalSM]

You just saved my life! Thanks bro!

[@saullapointe5448]

Thanks for sharing. the video is so helpful. i got windows 7, when i aply the >= and

[@excelisfun]

I am not sure what is going on.

[@heheh92]

Thank you so much for this just watched a 4year old video Excel for Accounting you did! So helpful. Can you do a video on Setting up a workbook for month end???

[@dilee2086]

Can you download on a Mac? Or I pad ?

[@bayezitsalgur3818]

I have an IGCSE test coming up soon. This helped me alot. Thank you ExcellsFun!

[@rambdrchand6354]

can you please help me out to prepare abstract of construction cost, as being a civil engineer, thanks

[@xdinic]

Very good explanation. :D

[@ziarahmani1188]

Hi, amazing videos always enjoyed and found them very useful. wondered if you would be or could be help me with something involving date with if and And F

[@truthtolight8188]

can you please repeat where to go to get your worksheets, to follow along with? Thank you.

[@excelisfun]

people.highline.edu/mgirvin/ExcelIsFun.htm In the Excel Basics section, choose the 2007 workbook.

[@TipsyP]

Is there a way to change the true false to other words?