Excel Basics #22: IF function formula made easy!

[kjhmario]

Great video! helped me a lot! :)

[ExcelIsFun]

@kjhmario , I am glad that it helped!

[AmazingEvents1]

Great videos

[ExcelIsFun]

@AmazingEvents1 , Glad you like it!

[dukk77777]

How can we make if fuction , to a discount... I mean the discount only applied to orders with quantity 2 or more?

[Kazshmir]

FORMULA!

[fabiola1ist]

this is a great video. I would like to know how I can reach all your videos through you tube, there are other facilitators but you are awesome.

Fabiola

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

[SalehMagrabi]

Hello... could you help me ?

this is what i am trying to do:

let us suppose that we have three cells: A1 B1 C1

C1=A1-B1 but i wanna add this "if A1<B1 C1 will be 0"

So i will not get negative numbers in the cell C1 ?

how can i do that ?

[ExcelIsFun]

In cell C1 Try:

=IF(A1<B1,0,A1-B1)

[SalehMagrabi]

@ExcelIsFun it did not work, it gave me error message, i am using office 2010

[ExcelIsFun]

I do not know how to do it then. Sorry.

[SalehMagrabi]

@ExcelIsFun I am sorry you are right, but you should use Semicolon ( ; ) instead of Comma ( , )

anyway thanks for help :)

[FreddyT87]

I downloaded the workbook but there is are no more worksheets for this series in there. The las worksheet I have is Filter, no more IF and no VLOOKUP. Which worksheet do I have to download to use for the videos from #22 and beyond? Thanks a lot!

[ExcelIsFun]

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

[indianacowgirl07]

Thank you so very much! I watched many of your videos to get me through many assignments that I have had to do for an online computer class. It has been a while since I did anything with Excel. I was so stressed about how I was going to figure it all out on my own but I found your videos and you helped me out so much!!! Thanks again!

[ExcelIsFun]

You are welcome!!

[mulish59]

You are an amazing teacher. I wish you were my teacher when I went to the Uni. :)

[ExcelIsFun]

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

[studentgirl101]

this was really helpful..

Thanks! :)

[ExcelIsFun]

You are welcome!

[manrajabi]

i downloaded your classes, so many thanks

[ExcelIsFun]

You are welcome!

[narmak1997]

Im doing a survey in which i have to find out if it is healthy or unhealthy and i use this formula

=IF(J1>=620,Unhealthy,Healthy)

and then microsoft says theres a error with the "IF" part what do i do

[ExcelIsFun]

You have to put text in double quotes, like:

=IF(J1>=620,"Unhealthy","Healt­hy")

The video illustrates the concept of Double Quotes for text in the "In Balance" example.

[narmak1997]

@ExcelIsFun

thanks

[ExcelIsFun]

You are welcome!

[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]

You are welcome!

[erodpacaon]

thx its working very well btw can i ask another favor.. im working in loan motrocycle i want to know if the customer will have a discount... if my costumer is paying on the ryt time he will get 200 discount.. if the costumer is over the due ex.. his due date is 9 and his datepaid is 4/29/1he will get the half discount too because is within the month. and if the collector grant the custommer 200 pesos even his is past due the collector will get a charge back.. thx in advance

[erodpacaon]

it works your the best!!!!!

[erodpacaon]

thx for the reply ill try it thank you very much, more power and god bless you

[erodpacaon]

i have a problem: a1 is duedate: b1 is date pay:, due date is 12 and date paid 4/15/11 i want to compute if day only not year and month heres my work =if(a1>=b1), "notdelay","delay" but itsnot working... i want 12 and 15 to work only

[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")

[erodpacaon]

Help me pls

Due date Date Pay 7 4/11/11 =if(a1>b2,"delay",not delay)

i want the day to tally not the month and year. how can i do this i want to show in my excel delay and not delay only pls help me

[ExcelIsFun]

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

[YouWantAnything]

LOVE YOU MAN

[ExcelIsFun]

I am glad you liked the videos!

[depaull]

Agree with " thisisouraccount " with whole heartedly

[ExcelIsFun]

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

[thisisouraccount]

u r best teacher in whole universe

[ExcelIsFun]

I am glad it helps!

[cinqueottavi]

And what if a cell doesn't contain an exact match? For ex. what if I want to match just only the date 2011-01-04,17:13:15 and not the hours?

[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),val­ue_if_true,value_if_false)

[TheSuiz]

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

[ExcelIsFun]

I am glad it helped!

[fastfast121]

thank you

[ExcelIsFun]

You are welcome!

[LauraSmith70563]

this is the best for learning specific parts of excel that I need!! thanks for the download and sharing with us! You really teach the best--(I've found on youtube) and make it so simple and easy to follow with your spreadsheets!!

thanks a million!!

Laura

[ExcelIsFun]

You are welcome!

[evahov01]

Hi thank you for the tutorials im having problems with a currency exchange table im creating for a school assignment I was wondering if you can take a look at itto see what Im doing wrong.

[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

[Asherali313]

i have one question i made a work sheet for gasoline inventory and problem i am having is that some of the month end on 30 and some on 31 and feb on 28.

now what kind of formula i should put in to that column where it checks the last cell with number dont meter if it end on 15th of the month or 31 st of the month i want the value of last cell with number in same column. can you help me

[ExcelIsFun]

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

[Asherali313]

thank you very much!



[ExcelIsFun]

You are welcome!

[Asherali313]

hey there i want my work sheet to take only number or numeric data what i have to do?

[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

[BlackmetalSM]

You just saved my life!

Thanks bro!

[ExcelIsFun]

You are welcome!

[gelolo020407]

you are a big help my friend. keep up the good work.

[ExcelIsFun]

I am glad that the videos helped!

[gaurhari]

You beauty!!!! This is just amazing.......

Thanx a lot

[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!

[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 :)

[ExcelIsFun]

I am glad that you like it!

[TheLoFiction]

love it ;) thank you

[ExcelIsFun]

You are welcome!

[residualincome4life1]

You make make excel interesting and fun

[ExcelIsFun]

I am glad that you liked the videos!

[timmycook58]

your videos are great! managed to apply some of these secrets to the organisation I work for and they love me now!

[ExcelIsFun]

I am glad that the videos help!

[xMATTSTERx]

Is it possible to have more than 2 values? I have 3 values 25,45,75 and 3 statments. Small medium and large. I need to link them all using an "IF" and "drop down list".

[nicoscocos]

You are amazing - thanks!

[ExcelIsFun]

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

[deathdude333]

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

[ExcelIsFun]

I am glad that the videos help!

[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 these help! Remember to rate all videos 5 stars!!

[lexingtonlp]

You are the best teacher ever! Thank you so much!

[ExcelIsFun]

You are welcome!

[gauravmarine]

thanks.

[ExcelIsFun]

You are welcome!

[flash2303]

waitt.. did you put the extra penny there to prove a point or does it happen automatically and u need to fix it?

[ExcelIsFun]

What minute are you referring to in the video?

[flash2303]

8:26

[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!

[tuabantorogi]

i'm learning a lot from your videos, thanks a lot! btw, could u pls help me... i'm calculating the grades of my students. i had already calculated their average grades. now i want to assign a "letter grade" to each corresponding average grades, ie: A = 90 to 100, B = 80 to 89, C = 70 to 79, D = 60 to 69, F = 59 - 0. thanks in advance for your help

[ExcelIsFun]

Don't use IF, use VLOOKUP.

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

[jsprincessrue6]

i love u, God blesses people like u!!!!!

[ExcelIsFun]

I am glad that you like the video!

[SFDSea]

You are a great Educator (notice capital E). Thank you

[ExcelIsFun]

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

[ExcelIsFun]

I have many. Serach for this Playlist title:

Various Excel Separate Text (like First Last Names) Tricks

[afin85]

is this #22 or #23 at the beginning you say 23 but title says 22

[ExcelIsFun]

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

[Deathmess01]

Hi im looking to make an auto spreadsheet to work out wat i need (in total) to build stuff in a game. im try to make it so all i have to do is type in the name of the item and it will show me wat i need of each minerial to make the item.

[ExcelIsFun]

Try this video title:

Magic Trick 335: VLOOKUP & Data Validation for Recipes

[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

[ExcelIsFun]

Dear Obee7,

I am glad that the videos are useful!

I don't have any MS Access videos.

--excelisfun

[electricwave]

These videos are so useful and so well explained. It's funny, cause I was going to ask the same question.

[ExcelIsFun]

Dear electricwave,

I am glad that there are useful!

--excelisfun

[mykstrung]

Hi,

do you have powerpoint lessons also? hehehe!

[ExcelIsFun]

Dear mykstrung,

No, just Excel!

--excelisfun

[chippendails]

thanks for this super help

[ExcelIsFun]

Dear chippendails,

I am glad that it helped!

--excelisfun

[XUltra00]

Thanks a lot man,

ive always hated excel

but thanks to your videos ive made a lot of progress during maybe 1 day only

theyre clear and funny explained but u talk to fast

lessons a lot better than my crappy textbook

Kepp it up!!! :-)

[ExcelIsFun]

Dear XUltra00,

I am glad that the videos are helpful.

--excelisfun

[maxandbrener]

Thank you for everything!

[ExcelIsFun]

Dear maxandbrener,

You are welcome for everything!

--excelisfun