Master the IF Formula in Excel (Beginner to Pro)

[@KenjiExplains]

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

[@Qalbal_iman07]

hey Kenji , you explained so well , i watch your videos a lot , i want to become a data analyst and your program of data analyst seems quite fascinating , but i am unable to purchase it , i am from a underdeveloped country , the prices are much higher, we can't even afford that , do you have any financial aid for these certificates , like just other websites usually have , i really want to complete your data analyst course , if you are willing to do so will you help me to access that for free with a certificate , i'll be thankful to you for this kindness , thank you.

[@Aamiranalyst]

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

[@KenjiExplains]

Thank you for your lovely comment!

[@Aamiranalyst]

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

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

[@BlessingIkechukwu-q1z]

Honestly...he is trying

[@hanifiddrisu]

If I want to enroll in this. How will I start please

[@felixg7735]

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

[@KenjiExplains]

thank you!

[@EffigyOfAdam]

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

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

[@mohammedmamari7167]

this is the best tutor of excel that i have even seen during my last 5 years big like thumb for you and keep the good work

[@KenjiExplains]

Thank you so much!

[@guillermofernandez6884]

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]

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

[@adderlyacevedo8232]

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

[@xiomaracuerodaza5930]

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]

Thank you! 😃

[@ajaypawar9454]

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

[@fiqixirs5666]

Thank you Kenji the way you explain it is so interesting I used to learn in KZbin for awhile but never seen such talented teaching techniques

[@hoanglong_196]

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

[@joanned.100]

Yes, that is awesome!

[@XLLearner_Courses]

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

[@Gug2198]

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

[@techcorner2024]

Making it very simple to understand. Thank you

[@kennykrabss]

Best Excel tutorials out there👌🏻

[@KenjiExplains]

Glad you think so! thanks for watching :)

[@md.salahuddintitu2784]

One of my favorite channel. Thanks Kenji

[@fatimazaim503]

Thanks so much for these tutorials!

[@rafikiallan3736]

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

[@KenjiExplains]

Thank you!!! Really appreciate your comment 😁

[@jamshedmaqsudov1279]

Great man. Very informative and precisely explained everything !

[@campingadventures8760]

THANKS FOR YOUR VIDEO, I'M REALLY LEARNING IT,I'M A BENNIGER LEVEL. WATCHING FROM PUERTO RICO

[@lulubelle307]

Thank so much for explaining this I was getting so frustrated.

[@ashanisomarathne8859]

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

[@neremoli4990]

Best presentation, I am learning some new concepts

[@manikantabejgam2591]

The video editing skill is just another level.... Fantastic. Make a video of excel video editing

[@gabugo2923]

Your tutorials are the best it was a refresher for me Thank you!!!

[@musamaiza6259]

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

[@Ramusacol]

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

[@badnarobot]

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

[@amybatuhan]

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

[@jennymahany2667]

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

[@3mmapipFX]

The best man ever

[@KAHUNDEELIZABETH-c7z]

This is so incredible and amazing.

[@blessingene2227]

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

[@MagudeswaranM-p4m]

@Kenji Explains, Insightful way and nicely explained the IF, SUMIF Conditions with perfect examples 👌

[@sandrasanchez6671]

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

[@henryto9194]

Thank you very much for this amazing tutorial

[@clayton88390]

Kenji the goat let’s goooooo

[@ajaypawar9454]

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

[@hadgubelay6501]

Thank you Kenji

[@b.e.icompany1939]

Excellent presentation. Thanks a lot.

[@KenjiExplains]

Glad it was helpful!

[@andrewleventis8341]

well done good videos to the point and well explained thanks from S Africa

[@AkashGupta-fm2ys]

Very good teaching dear.

[@Velcos_Mix]

I love this wild card💕

[@bnn797]

Simply amazing...Thank you!

[@FriedaOngley]

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.

[@ArvinOrtega-e8u]

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

[@umarashraf5102]

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

[@amusaazeez4410]

Keep on good sir , I like the way you teach

[@steven.h0629]

I like the ampersand wildcard tie 👍😎✊

[@rashmimishra2177]

thank You kenji

[@shoppersdream]

Nice, thanks! It would help if you also put your questions so we can try it first. Thanks

[@hansangello4671]

Thank you so much ❤

[@ayeshamaqsood7655]

I am using your excel course 🎉 great gob

[@Ay-md1lj]

Thank you

[@UsmanKhan-tj4ut]

Excellent content, thank you

[@khalidsudani-ni8jo]

smart teacher thank you very much for the lesson

[@zenkydeecee59]

Thank you so much for this very informative video.

[@KenjiExplains]

Glad it was helpful!

[@naingtun6620]

Thank you for sharing

[@believenwanesi8594]

Well detailed ,take your flowers 🎉

[@b.r.srihari4099]

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

[@KenjiExplains]

Thanks a lot!

[@ramnishadkuttuva9306]

very useful information thanks

[@CideeStudio]

Easy to understand

[@marcymcflybv1558]

I hope I can get in touch with you. Been dealing with a nested IF statement that I really can't figure out. It's something like: Number of conditions - 3 Number of return value - 4 Help? 😅

[@adderlyacevedo8232]

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

[@KenjiExplains]

Glad you liked it!

[@soyoyeoluwafunso4586]

Wow this is great thank you ..

[@wilmaostman7537]

Love your videos

[@azmary986]

Simply Amazing

[@nehes]

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

[@DicksonThoke]

Interesting video, thanks for sharing

[@KenjiExplains]

Thanks for watching!

[@RohitThakur-en7qw]

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

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

[@gekalskip]

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

[@IreoluwaDanielAdegoke]

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

[@otuefiom5730]

@KenjiExplains what's the best formula for a 3 criteria problem in excel?

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

[@chechewambi4002]

so educative

[@eddieme2009]

Nice content 👍

[@stalker6887]

You are great.. thank bro..

[@hnquran1002]

Thank you bro

[@tourkofagos7484]

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.

[@Pardesstruggles]

Love u bro ❤

[@pastorsinho]

Bravo. Thanks

[@PawanSharma_]

Hi, Pls share excel file also for Practise.

[@maksymiliankobus2458]

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?

[@judithcarper]

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

[@mulukendesalegn-v7k]

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

[@jamesmaimalupuk]

Hay Mate, It's really helpful if you can send me the last formula right at the end of your video. Really appreciate it.

[@giorgimodebadze1869]

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

[@ictkenyar]

Learnt something

[@PixelPioneer37]

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

[@teddyw.charawa8989]

You are a billionaire in the making!!

[@samar1218]

I love it and I love you so much 😍

[@KenjiExplains]

haha thanks you

[@samar1218]

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

[@mahmoudmostafa1371]

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

[@knowledgeworld1506]

Hy guy, you seem to be eagerly interested in learning excel visit kzbin.info/door/Ux2 to learn more.

[@itsmae1992]

Tutorial for Inventory Management system in excel pls

[@j-suahcomedyshouse5888]

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.

[@DanishAhmedperspectives]

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?

[@nishanth4323]

Thank you 😊👍

[@KenjiExplains]

Thanks for watching!

[@nishanth4323]

@@KenjiExplains 😊🫂

[@faizulamrisarkom6062]

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]

Use the IFS formula like his second example

[@Nishasingh-04]

Sir please explain 10.10+-0.05 OK NG

[@FriendsGuide]

I want MS Excel to change from numbers I like to numbers letters I like example 1= w f s o, 2 = j o h n, 3 = c r p c It is possible ?plz help me sir