Master the IF Formula in Excel (Beginner to Pro)

Поділитися
Вставка
  • Опубліковано 24 гру 2024

КОМЕНТАРІ • 183

  • @KenjiExplains
    @KenjiExplains  Рік тому +11

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

    • @Qalbal_iman07
      @Qalbal_iman07 2 місяці тому +3

      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
    @Aamiranalyst Рік тому +71

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

    • @KenjiExplains
      @KenjiExplains  Рік тому +4

      Thank you for your lovely comment!

    • @Aamiranalyst
      @Aamiranalyst Рік тому +3

      @@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
      @sheeplestrafer9413 8 місяців тому

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

    • @BlessingIkechukwu-q1z
      @BlessingIkechukwu-q1z 7 місяців тому

      Honestly...he is trying

    • @hanifiddrisu
      @hanifiddrisu 6 місяців тому

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

  • @felixg7735
    @felixg7735 Рік тому +15

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

  • @EffigyOfAdam
    @EffigyOfAdam 6 місяців тому +4

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

  • @weedybaiz1458
    @weedybaiz1458 29 днів тому

    i have my excel exam today and u r SAVING ME I LOVE U KENJI

  • @kennykrabss
    @kennykrabss Рік тому +5

    Best Excel tutorials out there👌🏻

  • @xiomaracuerodaza5930
    @xiomaracuerodaza5930 Рік тому +2

    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 !

  • @onildomagalhaes3892
    @onildomagalhaes3892 7 місяців тому +3

    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
    @mohammedmamari7167 2 місяці тому +1

    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

  • @guillermofernandez6884
    @guillermofernandez6884 Рік тому +7

    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
      @KenjiExplains  Рік тому

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

    • @adderlyacevedo8232
      @adderlyacevedo8232 Рік тому

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

  • @ajaypawar9454
    @ajaypawar9454 8 місяців тому +2

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

  • @Gug2198
    @Gug2198 11 місяців тому +1

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

  • @XLLearner_Courses
    @XLLearner_Courses Рік тому +2

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

  • @badnarobot
    @badnarobot Рік тому +1

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

  • @md.salahuddintitu2784
    @md.salahuddintitu2784 Рік тому +1

    One of my favorite channel. Thanks Kenji

  • @ashanisomarathne8859
    @ashanisomarathne8859 Рік тому +1

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

  • @hoanglong_196
    @hoanglong_196 Рік тому +2

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

    • @joanned.100
      @joanned.100 9 місяців тому

      Yes, that is awesome!

  • @fatimazaim503
    @fatimazaim503 10 місяців тому +1

    Thanks so much for these tutorials!

  • @fiqixirs5666
    @fiqixirs5666 4 місяці тому

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

  • @jamshedmaqsudov1279
    @jamshedmaqsudov1279 10 місяців тому +1

    Great man. Very informative and precisely explained everything !

  • @clayton88390
    @clayton88390 Рік тому +1

    Kenji the goat let’s goooooo

  • @techcorner2024
    @techcorner2024 Рік тому +1

    Making it very simple to understand. Thank you

  • @rafikiallan3736
    @rafikiallan3736 Рік тому +3

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

    • @KenjiExplains
      @KenjiExplains  Рік тому

      Thank you!!! Really appreciate your comment 😁

  • @neremoli4990
    @neremoli4990 Рік тому +1

    Best presentation, I am learning some new concepts

  • @campingadventures8760
    @campingadventures8760 5 місяців тому

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

  • @sandrasanchez6671
    @sandrasanchez6671 Рік тому

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

  • @3mmapipFX
    @3mmapipFX Місяць тому

    The best man ever

  • @DharshanDon-w7z
    @DharshanDon-w7z 27 днів тому

    thank you so much sir learnt more things from your and videos.

  • @Velcos_Mix
    @Velcos_Mix 10 місяців тому

    I love this wild card💕

  • @jennymahany2667
    @jennymahany2667 11 місяців тому +1

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

  • @KAHUNDEELIZABETH-c7z
    @KAHUNDEELIZABETH-c7z Місяць тому

    This is so incredible and amazing.

  • @amybatuhan
    @amybatuhan Рік тому

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

  • @Ramusacol
    @Ramusacol 7 місяців тому

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

  • @henryto9194
    @henryto9194 6 місяців тому +1

    Thank you very much for this amazing tutorial

  • @gabugo2923
    @gabugo2923 4 місяці тому

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

  • @musamaiza6259
    @musamaiza6259 Рік тому

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

  • @hansangello4671
    @hansangello4671 Місяць тому

    Thank you so much ❤

  • @MagudeswaranM-p4m
    @MagudeswaranM-p4m 6 місяців тому

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

  • @b.e.icompany1939
    @b.e.icompany1939 2 місяці тому

    Excellent presentation. Thanks a lot.

  • @manikantabejgam2591
    @manikantabejgam2591 4 місяці тому

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

  • @steven.h0629
    @steven.h0629 Рік тому

    I like the ampersand wildcard tie 👍😎✊

  • @ArvinOrtega-e8u
    @ArvinOrtega-e8u Рік тому +1

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

  • @gekalskip
    @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

  • @shoppersdream
    @shoppersdream 3 місяці тому

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

  • @ajaypawar9454
    @ajaypawar9454 8 місяців тому

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

  • @PixelPioneer37
    @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

  • @FriedaOngley
    @FriedaOngley 8 місяців тому

    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.

  • @blessingene2227
    @blessingene2227 6 місяців тому

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

  • @UsmanKhan-tj4ut
    @UsmanKhan-tj4ut 10 місяців тому

    Excellent content, thank you

  • @lulubelle307
    @lulubelle307 Місяць тому

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

  • @believenwanesi8594
    @believenwanesi8594 8 місяців тому

    Well detailed ,take your flowers 🎉

  • @ayeshamaqsood7655
    @ayeshamaqsood7655 4 місяці тому

    I am using your excel course 🎉 great gob

  • @Ay-md1lj
    @Ay-md1lj Рік тому +1

    Thank you

  • @brianchitundukawimbe5135
    @brianchitundukawimbe5135 Місяць тому

    Thanks a million

  • @amusaazeez4410
    @amusaazeez4410 7 місяців тому

    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

  • @wilmaostman7537
    @wilmaostman7537 Рік тому

    Love your videos

  • @AkashGupta-fm2ys
    @AkashGupta-fm2ys 6 місяців тому

    Very good teaching dear.

  • @zenkydeecee59
    @zenkydeecee59 10 місяців тому

    Thank you so much for this very informative video.

  • @bnn797
    @bnn797 Рік тому +1

    Simply amazing...Thank you!

  • @RohitThakur-en7qw
    @RohitThakur-en7qw 10 місяців тому

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

  • @hadgubelay6501
    @hadgubelay6501 4 місяці тому

    Thank you Kenji

  • @ramnishadkuttuva9306
    @ramnishadkuttuva9306 Рік тому

    very useful information thanks

  • @b.r.srihari4099
    @b.r.srihari4099 Рік тому +1

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

  • @andrewleventis8341
    @andrewleventis8341 5 місяців тому

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

  • @tourkofagos7484
    @tourkofagos7484 11 місяців тому

    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.

  • @adderlyacevedo8232
    @adderlyacevedo8232 Рік тому +1

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

  • @umarashraf5102
    @umarashraf5102 7 місяців тому

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

  • @amusaazeez4410
    @amusaazeez4410 7 місяців тому

    Keep on good sir , I like the way you teach

  • @naingtun6620
    @naingtun6620 6 місяців тому

    Thank you for sharing

  • @mulukendesalegn-v7k
    @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

  • @rashmimishra2177
    @rashmimishra2177 4 місяці тому

    thank You kenji

  • @khalidsudani-ni8jo
    @khalidsudani-ni8jo 8 місяців тому

    smart teacher thank you very much for the lesson

  • @soyoyeoluwafunso4586
    @soyoyeoluwafunso4586 Рік тому

    Wow this is great thank you ..

  • @IreoluwaDanielAdegoke
    @IreoluwaDanielAdegoke Рік тому

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

  • @DicksonThoke
    @DicksonThoke Рік тому

    Interesting video, thanks for sharing

  • @DanishAhmedperspectives
    @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?

  • @otuefiom5730
    @otuefiom5730 2 місяці тому

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

  • @eddieme2009
    @eddieme2009 Рік тому

    Nice content 👍

  • @marcymcflybv1558
    @marcymcflybv1558 4 місяці тому

    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? 😅

  • @zainohamid8017
    @zainohamid8017 9 місяців тому

    Pretty good❤❤❤❤

  • @Pardesstruggles
    @Pardesstruggles 11 місяців тому

    Love u bro ❤

  • @judithcarper
    @judithcarper 8 місяців тому

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

  • @azmary986
    @azmary986 Рік тому

    Simply Amazing

  • @chechewambi4002
    @chechewambi4002 8 місяців тому

    so educative

  • @maksymiliankobus2458
    @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?

  • @stalker6887
    @stalker6887 8 місяців тому

    You are great.. thank bro..

  • @j-suahcomedyshouse5888
    @j-suahcomedyshouse5888 10 місяців тому

    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.

  • @mohammadmahdibarati6818
    @mohammadmahdibarati6818 Рік тому

    Great 🎉

  • @nehes
    @nehes 10 місяців тому

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

  • @boopathi-srisaiganeshpacka3071
    @boopathi-srisaiganeshpacka3071 Місяць тому

    i need Help. if formula. Example Corrugated Box inner Dimension(ID) and Outer Dimension(OD) if i am using ID means box size add 3 or 5mm . IF i am entering OD means want to show orginal value. pls help us

  • @Pardesstruggles
    @Pardesstruggles 11 місяців тому

    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
    @samar1218 Рік тому

    I love it and I love you so much 😍

    • @KenjiExplains
      @KenjiExplains  Рік тому

      haha thanks you

    • @samar1218
      @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

  • @giorgimodebadze1869
    @giorgimodebadze1869 Рік тому +1

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

  • @mumarghani5002
    @mumarghani5002 7 місяців тому

    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
    @kstout216 Рік тому

    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

  • @mohammedel-guindi698
    @mohammedel-guindi698 Рік тому

    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

  • @teddyw.charawa8989
    @teddyw.charawa8989 7 місяців тому

    You are a billionaire in the making!!

  • @neremoli4990
    @neremoli4990 Рік тому

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

  • @itsmae1992
    @itsmae1992 Рік тому

    Tutorial for Inventory Management system in excel pls

  • @CideeStudio
    @CideeStudio 5 місяців тому

    Easy to understand