IF Function in Excel Tutorial

you need to sleep a bit, you too tired

Thank you!

You’re the best Ryan Seacrest!

Agree. One of the best functions.

Thank youu!!

What does an airplane run on

I was hoping to get the IF formular where If a number is less than zero (for example), then the cell takes Zero, and if it's greater than Zero, then it takes the Number. Any help?

Im watching this on my phone. Its way to small to see the details of the formula youre typing. I suggest creating a text box to show the formula as you type it. In formulas the details are very important. We need to see the details of each logic box.

that's not a function. that is a formula. thanks for correctly labeling things.

Good one.

Pls Mr Kelvin can u give more tutorals on excel

Thank you, your video solved the issue, after looking at many videos

Thank you so much; you made it so easy to understand!

Subscribed😁

Well explained thanks

I just used the lesson learnt to answer a question in few seconds😊 Thank you Kelvin.

Can you please show me how to add massive amounts of data into excel without typing each amount?

hey kev, please use nested if statement whereby a teacher can assign grades to the learners mark, for instance if its 60% the grade will be C. and also please use vlookup to also assign grade whereby you will create a table on the side with the parameters of grades boundaries, lowest score and grade value.

Am interested so can we have a WhatsApp group plz

Kevin, I was hoping you could send some advice or point me in the right direction:
I am trying to create a score sheet and the if/then basic formula doesnt work because the = isnt just yes or no.

There are 5 attempts per round. the scorekeeper is either putting a 1 or a zero (hit or miss). If the person hits the first one, it is 5X the score. 2nd shot is 4X the distance, etc. The "value" changes each round, with each round being 5 attempts. Example with 500 being the distance:
=IF the score in C9 = 1, THEN (5*500) if not THEN zero
=IF the score in D9 = 1, THEN (4*500) if not THEN zero
=IF the scote in E9 = 1, THEN (3*500) if not THEN zero
so on, and so forth.
to make it interesting, I want all the values to add at the end of the card.
I just dont know how to get the THEN to calculate rather than be a simple number/text.
I know this is a lot to ask- but as a fellow PNW person, I am hoping you can at least tell me if its even possible or if I need a different program! I have Office 365 and use Sharepoint, Teams, and all the programs associated with that.
THANK YOU!!!!

Thank you so much. I was about to fall apart trying to do my homework. You’re a life saver 😭

Here I am, looking at Excel tutorials because I haven't used it in years. Ahhhhh, I have been doing this in Python for a good while, why does my brain not want to do Ifs in Excel lmao

Thank you!

Excellent teaching 👍🏻👍🏻👍🏻

Thanks

Thank you ✌

How can I compare an empty cell and return a value if it is empty (no value in the cell) with the if function? Is it something like if C8=" "? Please help

thank you so much. I am budgeting at the moment and new to excel. This video gave me a lot of information on how to effectively plan my spend!

What if you don't want a "false" result? I want the cell to remain blank if the statement is false.

Best tutorial ever.

Thank you for your help sir ❤️

Thanks man!

Thank you, made it simple for my introduction to IF function.

I would like to analyse my credit card statements in Excel and assign each expense to a category like gasoline, groceries , dentist etc. to arrive at an annual spend on each of the categories.

So many words

I need something similar to this. If the value is over 11 digits, remove digits from the left (the beggining of the value) to make it 11 digits. If the value is under 11 digits, add preceeding 0's to make it 11 digits.

What if I want to use a "=date" formula for if the statement is true or false? For example, if something is true then it will populate a date that is one year later and if false the date is only 3 months later. Can that be done and if so how?

Thank you Kevin :) You make learning all of these functions so much easier. You are the best!!!

thx sooo much

Thank you

I want to use the if function to find a certain name within a column infinitely. To trigger a sum function for a specific cell within the row that the name occurred on a separate sheet.. So we have different drivers doing different jobs and I want to keep running totals of each drivers totals fares on a separate sheet. Then repeat for each individual driver. Then each week is gonna have its own sheet. I’m going to copy my formulas for each sheet to create the next week. So if possible have it continue onto the next sheet or at least keep weekly totals that I can carry and summarizing it from there will be easy. Thank you

you are the best teacher

Your video's are very useful, you made me like excel.

Hi!, my name is Kevin as well

Im struggling with the following formula I would like to use.

Column B has got text. With discriptions and names etc.
Column B is in a table called (discription)
For this column I use the =IF(COUNTIF(discription,''*abc*'',''A'',"")
But I want to add another if to this formula for example =IF(COUNTIF(discription,''*123*'',''B'',"")
And 3 to for more IF('s)

Im stuck, hope someone could give some advice ✌️🙏

I want to verify that a certain value is on a list and return that it exists on a list or not. What is the best vid for that?

I very interested to learn other excel function, how can you notify me of your every tutorial video on solving excel function, thank you.

Very helpful. Couldn't remember how to use the IF function. Video was great help.

Thanks for this!

Thank you for making it so simple