Master the IF Formula in Excel (Beginner to Pro)

Подписаться 522 тыс.

Просмотров 361 тыс.

50% 1

IF Function tutorial in Excel with five examples from easy to hard.
👉 Take our Excel course! www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
The IF Function is probably the most important function you can learn in Excel. So in this video, I've put together 5 examples of how to use it from easy to hard. First, we'll start with a simple IF statement with greater than as the logical test. Then, we'll learn the IFS formula. Third, we'll learn to combine formulas such as the IF AND. Fourth, we'll look at other formulas that use IF such as the SUMIFS or the COUNTIFS. Finally, we'll look at using the wildcard with the SUMIFS formula. After this IF function tutorial on Excel, you should be able to apply the IF formula to any work setting.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - IF Formula Simple
2:12 - IFS Formula
3:58 - IF AND Formulas Combination
6:11 - SUMIFS Formula
8:27 - Wildcard Formula Feature
Disclaimer: I may receive a commission on some of the links provided at no extra cost to you.

Опубликовано:

14 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 139

@KenjiExplains 8 месяцев назад

🔥Take our Excel course: www.careerprinciples.com/courses/excel-for-business-finance

@EffigyOfAdam 8 дней назад

This is the best part of RU-vid...good teachers. Cant find a Kenji at a college. Love it

@musamaiza6259 6 месяцев назад

You so kind in your teaching method, making it so easy to learn. God bless you richly.

@md.salahuddintitu2784 8 месяцев назад

One of my favorite channel. Thanks Kenji

@jennymahany2667 5 месяцев назад

This has been so helpful and you explain it in great detail!! Thank you!!

@user-wq2cf2oj3g 7 месяцев назад

Thank you for sharing your knowledge to us. Highly appreciated 💙

@ajaypawar9454 Месяц назад

way you teach IF, IFS, Sum IFS functions is on next level. Ooosome, Thank you🙏

@onildomagalhaes3892 Месяц назад

Hi Kenji I'm Wezza from Angola I'm an enthusiastic excel and I'm impressed by the clear and simple way you explain complex formulas with the if statement.

@Aamiranalyst 7 месяцев назад

I have been using Microsoft Excel since 2017 but the way you teach IF, IFS, SumIFS functions is on next level

@KenjiExplains 7 месяцев назад

Thank you for your lovely comment!

@Aamiranalyst 7 месяцев назад

@@KenjiExplains it's my pleasure to appreciate you because you are one of them who are changing newbies life to teaching top class IT field

@sheeplestrafer9413 2 месяца назад

Personal tips on how to learn from basically zero, would be helpful. Where should I start when first learning excel?

@user-oi9cg4fc5b Месяц назад

Honestly...he is trying

@felixg7735 6 месяцев назад

Excellent presentation, your grasp of the subject is quite impressive, but how you explain all the concepts is even more impressive IMHO.

@KenjiExplains 6 месяцев назад

thank you!

@techcorner2024 8 месяцев назад

Making it very simple to understand. Thank you

@Ramusacol 17 дней назад

The way you explain this topic is really clear. Thanks.

@jamshedmaqsudov1279 3 месяца назад

Great man. Very informative and precisely explained everything !

@fatimazaim503 4 месяца назад

Thanks so much for these tutorials!

@Beeboo-boobop 7 месяцев назад

Thank you so much for this. I am going to share this with my whole class.

@rafikiallan3736 7 месяцев назад

You make learning fun. Keep up the good work and thank you Kenji.

@KenjiExplains 7 месяцев назад

Thank you!!! Really appreciate your comment 😁

@amybatuhan 6 месяцев назад

Thank you! It's the " " explanation! I finally nailed my formula ❤❤❤

@ajaypawar9454 Месяц назад

thank you very much. i am struggling for IF function formula but you explain in best way now i learnt all .

@hoanglong_196 8 месяцев назад

Hey Kenji! The wildcard saved me tons of time. Thanks so much!!!

@joanned.100 3 месяца назад

Yes, that is awesome!

@Gug2198 5 месяцев назад

Thank you, It is very simple and easy to understand.

@ashanisomarathne8859 8 месяцев назад

I used the shortcuts and functions in my job related exam, I passed it at got my job too❤ Tysm Kenji...

@badnarobot 6 месяцев назад

❤❤❤ it’s a wow. Thanks for this short presentation

@bnn797 8 месяцев назад

Simply amazing...Thank you!

@blessingene2227 4 дня назад

Thank you so much for making it easy to understand the if function

@XLLearner_Courses 8 месяцев назад

Totally agree. Without this function my job would be so much harder.

@sandrasanchez6671 6 месяцев назад

Excellent, simple so simple but perfect.👍👍👍👍👍

@xiomaracuerodaza5930 6 месяцев назад

Thank you so much , English is not my first language, but you explain very good and speak clearly ,🤗 I’m happy that I found you !

@KenjiExplains 6 месяцев назад

Thank you! 😃

@neremoli4990 7 месяцев назад

Best presentation, I am learning some new concepts

@kennykrabss 8 месяцев назад

Best Excel tutorials out there👌🏻

@KenjiExplains 8 месяцев назад

Glad you think so! thanks for watching :)

@giorgimodebadze1869 8 месяцев назад

Hey kenji! Can you make a video about using VBA as financial analytics purpose? Thanks 🙏

@UsmanKhan-tj4ut 3 месяца назад

Excellent content, thank you

@guillermofernandez6884 8 месяцев назад

How interesting I had never heard about the wildcard formula. Data at my work tends to be messy this video is a godsend😂 thank you kenji

@KenjiExplains 8 месяцев назад

Awesome to hear! Thanks for letting me know glad it was helpful :)

@adderlyacevedo8232 8 месяцев назад

Yeah, neither have I! This just makes my job easier now.

@khalidsudani-ni8jo 2 месяца назад

smart teacher thank you very much for the lesson

@umarashraf5102 Месяц назад

your excel short videos are very well moreover concept clear compare to other one 👍

@ramnishadkuttuva9306 5 месяцев назад

very useful information thanks

@azmary986 5 месяцев назад

Simply Amazing

@Ay-md1lj 8 месяцев назад

Thank you

@amusaazeez4410 Месяц назад

Keep on good sir , I like the way you teach

@steven.h0629 8 месяцев назад

I like the ampersand wildcard tie 👍😎✊

@mahmoudmostafa1371 8 месяцев назад

I really wanted to thank you for your great effort❤❤I learned alot from your videos keep it up✌🏽✌🏽

@knowledgeworld1506 8 месяцев назад

Hy guy, you seem to be eagerly interested in learning excel visit ru-vid.com/show-UCUx2 to learn more.

@pahasha316 3 месяца назад

I love this wild card💕

@soyoyeoluwafunso4586 6 месяцев назад

Wow this is great thank you ..

@hnquran1002 8 месяцев назад

Thank you bro

@stalker6887 2 месяца назад

You are great.. thank bro..

@user-vx1te1ji2d Месяц назад

Thank you, thank you, thank you! Great tutorial. I was pulling my hair out trying to work out how to put the brokerage rate in for sales over and under 10,000 etc.

@pastorsinho 8 месяцев назад

Bravo. Thanks

@wilmaostman7537 6 месяцев назад

Love your videos

@adderlyacevedo8232 8 месяцев назад

Nice content! I didn't know the last trick, pretty interesting!!😲

@KenjiExplains 8 месяцев назад

Glad you liked it!

@b.r.srihari4099 8 месяцев назад

Nice and neat explanation ..... as always. Kudos

@KenjiExplains 8 месяцев назад

Thanks a lot!

@claytonlee839 8 месяцев назад

Kenji the goat let’s goooooo

@mohammedel-guindi698 7 месяцев назад

Hi, Your video about sumifs is very much great. Can Sumifs be combined with Vlookup? If it could be done, Pls. provide an explanation for it. Thank U. Regards

@zenkydeecee59 4 месяца назад

Thank you so much for this very informative video.

@KenjiExplains 4 месяца назад

Glad it was helpful!

@eddieme2009 8 месяцев назад

Nice content 👍

@chechewambi4002 2 месяца назад

so educative

@believenwanesi8594 2 месяца назад

Well detailed ,take your flowers 🎉

@user-gp2wj3br4r 7 месяцев назад

Thanks for sharing the wildcard IF function. Please can you share an approach to clean the data and produce only the country name.

@Pardesstruggles 4 месяца назад

Love u bro ❤

@user-dm8zs6xq7m 5 месяцев назад

I am happy about all your tutors but in this lesson /formula 3 &2/how do you take the =IF() from E3 TO D3? Regards

@DanishAhmedperspectives 6 месяцев назад

Hi, your video is great, I have a question, I want to create a formula that will only allow values from 600 to 1200 and do not allow other values to be entered. can you help?

@amusaazeez4410 Месяц назад

Thanks so much for the template on 3 financial modeling Where can get the video for beginners or is there anything site you can refer to We appreciate you

@nehes 4 месяца назад

Good tips and also please you will be make video, which is focused data duplication and sum of their value

@user-ho7vu1rt3w 6 месяцев назад

Interesting video, thanks for sharing

@KenjiExplains 6 месяцев назад

Thanks for watching!

@nishanth4323 8 месяцев назад

Thank you 😊👍

@KenjiExplains 8 месяцев назад

Thanks for watching!

@nishanth4323 8 месяцев назад

@@KenjiExplains 😊🫂

@ikhadeunupraise927 7 месяцев назад

Amazing

@mohammadmahdibarati6818 8 месяцев назад

Great 🎉

@ictkenyar Месяц назад

Learnt something

@maksymiliankobus2458 8 месяцев назад

Whats your opinion about ai and ongoing fear of replacing most of „corpo” jobs in near future? Would it be still worthy to get into finance career?

@tourkofagos7484 5 месяцев назад

Fantastic stuff, well done. Have you got a solution for the following, I need excel to calculate the number of hours and minutes between a range of hours, for example, between the hours of 19:00 and 6:00 I get 30 dollars, were from 6:00 to 19:00 my pay is 25 dollars an hour. What formula do I use to calculate the following scenario, I start at 18:00 and finish at 7:00, obviously my penalty hours are 11, and total hours are 13, I need the formula to give me the penalty hours worked within the total hours. I would appreciate any help.

@neremoli4990 7 месяцев назад

Can you write the formula for IFS function as shown in this video for me to look at it closely and apply.

@zainohamid8017 3 месяца назад

Pretty good❤❤❤❤

@RohitThakur-en7qw 4 месяца назад

Kenji Can we use Switch function instead of If functions??? Please make a video on Switch functions replacing If functions..

@judithcarper 2 месяца назад

What is the formula for not add the trike out amounts to your total? Thank you

@itsmae1992 6 месяцев назад

Tutorial for Inventory Management system in excel pls

@Nimal-yapa 3 месяца назад

Good

@mumarghani5002 Месяц назад

Hello respected sir...thank you for your good lecture ....but please solve my one question that i have..Which formula i should apply that...if sale increased from 100 give incentive 2% but does not increase dont give

@kstout216 6 месяцев назад

I’m looking to change the value of a cell on an anniversary date. I’m calculating longevity payments that increase $100 on an employees anniversary date but starts on their 5th year. Can it be done? Can you help? Thanks in advance

@Pardesstruggles 4 месяца назад

Please tell me if i have 50 sheets in one excel report and its all in same format, at the end there is master sheet so how can i vlookup by dragging down. My concern is if i am dragging down the formula sheet number must change please advise

@samar1218 6 месяцев назад

I love it and I love you so much 😍

@KenjiExplains 6 месяцев назад

haha thanks you

@samar1218 6 месяцев назад

I have to watch more of the valuation methods you have and more of the excel hacks for finance! Keep on posting please 😍😍 love you hehehe take care always

@j-suahcomedyshouse5888 3 месяца назад

Thanks for the lesson but I'm having little problem performing this function to find the sum where cell A1 contain 76 ,B1 87 C1 67 Divided by 3 plus 76 in cell D1 divided by 2 to display in cell E1. Please I need your help.

@gekalskip 5 месяцев назад

I've got a sheet with a column (C) with client ID's (formatted in 'general' and ranging from 1 to 10) and a column (D) with the hours of work i did for them (formatted in 'custom' as: hh:mm). Now I want to create a similar 'dynamic' overview table, like your example with spain and the olives, so that i can simply check my work for a specific client by filling in the client's ID number. I've got my formula like this: =SUMIFS(D3:D18,C3:C18,G3). So it's written exactly the same as the formula at 7:20 min in this video, but without a second criteria (i tried it with a second simple criteria but same result). It just doesn't want to work somehow. EDIT: apparently i needed to set the results cell to exactly the same format (hh:mm) for it to work. This really is a crucial aspect i feel gets left out a lot in these explanation videos. I get that you have to keep focused on the prime topic of the video, but it's such an important thing to overlook for a beginner. Speaking of which, all the examples given here are still rather simple. For me as a beginner it's hard to find mixes between different formats, like time (worked) and currency. 99% of examples on youtube just have simple bare numbers, which seems a lot easier to work with anyway

@PawanSharma_ 6 месяцев назад

Hi, Pls share excel file also for Practise.

@talibbb13 5 месяцев назад

10:20 We can enter this formula as well, right ```=SUMIFS(W4:W19,V4:V19,Z4,U4:U19,"*spain*")``` Don't need to put extra / unnecessary `&` sign. hope it helps

@RichardMoir-cb6jy Месяц назад

Kenji how do I send you a sample of an if formula i cant get right

@teddyw.charawa8989 29 дней назад

You are a billionaire in the making!!

@hussinali8858 2 месяца назад

Hi, how to create a formulae, eg: if in Column A1 is 1, therefore the Answer shall be the same as shown in it.

@xvikxpunx Месяц назад

I want to mark a blank cell (A2) with a color (with no text) if B2 has a specific text on it, once B2 has the text, I want to fill manually A2, I want that Excel advise me once B2 has the specific text but I want to receive the warning on A2 cell, can that be done? how do I do that if so? or that is not IF/Conditional formatting, thank you!

@ethilemzolo8493 6 месяцев назад

Good day Kenji, may I ask. How do I remove commas from a value in excel. For example, in a cell is R12, 234,984,00 my goal is to get R12 234 984,00

@camlex6310 8 месяцев назад

Great tutorial thanks!!

@rajasekaransundararaj6975 4 месяца назад

Hai sir I am very confused correcting current year in a result. Please help me fixing it. Tutorial says "Dates are stored as numbers in Excel because it allows for easier calculations and comparisons. You can, for example, add or subtract days from a date, or compare two dates to determine which is earlier or later. The number that represents a date is the number of days that have passed since January 1, 1900, when the Excel date system was introduced. The date January 1, 2021, for example, is stored as the number 44197 because it is 44197 days after January 1, 1900." I used all date formats in ms and wps to correct the formula. =(12/2/2024)+30 Ans I get 30-01-1900 Expecting your valuable help to correct this formula.

@humanconnection5646 Месяц назад

Hello friend, I am trying to learn from a free online course and not able move beyond one exercise if you can please help me solve this one. I don't think I will find a better platform than this to find help for my assignment.

@sharminferdousey8987 8 месяцев назад

Hi, may i know your excel version?

@oabonabonnykooagile2507 3 месяца назад

Cell B4 has 89 and cell C90 25 what will be the product at D91 using a formula. Kindly assist i am new to this

@willzinner8813 8 месяцев назад

can you also make some powerpoint videos?

@KenjiExplains 8 месяцев назад

Soon!

@nishanth4323 8 месяцев назад

@@KenjiExplains 😊👍

@maeamorrequillo9071 2 месяца назад

I want to learn excel badly! 😩

@faizulamrisarkom6062 7 месяцев назад

Can we put a string of IF function in a Cell? Examples: IF less than 1000 = 10marks, IF greater than 1000 AND less than 2000 = 20Marks, IF greater than 2000 = 30 Marks?

@gapurkis 6 месяцев назад

Use the IFS formula like his second example

@persiaxfanbase6883 Месяц назад

I would Like to make Something similar but with more than 2 Options. I have list of around 20 employees. In a further column it should Print the Teamname which this employees belongs to (4 Teams, some employees are in the Same Team).

@binkyfaith 6 месяцев назад

I have no clue about excel😩❤️

@melaniezhao4875 5 месяцев назад

I can't find "IFS" function

@russellrobinson4888 6 месяцев назад

Do you think I have a reasonable understanding of the "IF" function? This is a dynamic representation of calculating a tax liability, based on a variable taxable income and a tax table. =IF(D13>C51;(D13-C51)*E52+D52;IF(D13>C50;(D13-C50)*E51+D51;IF(D13>C49;(D13-C49)*E50+D50;IF(D13>C48;(D13-C48)*E49+D49;IF(D13>C47;(D13-D47)*E48+D48;IF(D13>C46;(D13-C46)*E47+D47;D13*E46))))))