How to Use IF Function in Excel (Step by Step)

Sdílet
Vložit
  • čas přidán 5. 08. 2024
  • IF function comes handy when you need to evaluate a logical condition and quickly find out whether it is true or false. In this tutorial, you’ll see how the function IF helps evaluate whether the sales for a particular month met the goal that had been set. If yes, Excel will display the message ‘Goal Achieved’. If the condition comes out as false, a horizontal stroke will show instead of the message.
    So, how can we use IF Function effectively? Let’s have a look at what the function does, to get an idea in what situations it can be used! IF Function is one of the most popular functions in Excel.
    ================
    Watch next video tutorial:
    Most popular Excel Functions
    ► • How to Calculate Diffe...
    How to Calculate Hours Worked in Excel (Midnight Span)
    ► • How to Calculate Hours...
    How to Check Spelling in Excel and Avoid Typos
    ► • How to Check Spelling ...
    ================
    ❤️ Become a Patron:
    Do you find our tutorials useful? Join this channel and become a patron
    CZcams ► www.youtube.com/@ExcelTutoria...
    ================
    ⏱️Timestamps⏱️
    0:00 How to Use IF Function in Excel
    1:03 What is the Syntax of the IF Function
    3:33 How to Copy the Function IF to the Rest of the Column
    5:35 IF Function is Dynamic
    ================
    Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)
    ► czcams.com/users/ExcelTutori...
    Transcription How to Use IF Function in Excel (Step by Step)
    ► www.easyclickacademy.com/how-...
    Got Microsoft Office 365? Get it here
    ► www.easyclickacademy.com/buy-...
    Connect:
    LinkedIn ► / easyclickacademy
    Facebook ► / easyclickacademy
    Screen Recorder & Video Editor:
    Camtasia ► techsmith.pxf.io/c/1266206/34...
    Voice over artist ► seanantonyvo.com
    #MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy
  • Jak na to + styl

Komentáře • 38

  • @rammsteinx6358
    @rammsteinx6358 Před 3 lety +16

    Thank you so much. Your tutorial is short, precise and easy to understand :)

  • @snowwhite2146
    @snowwhite2146 Před 3 lety +2

    I have watched some videos of your channel. You are a natural born teacher. Thank you for these amazing videos.

  • @gomolemomoholo3775
    @gomolemomoholo3775 Před 3 lety +4

    after struggling with this topic the whole day, this really helped

  • @jesusajasmincarin1647
    @jesusajasmincarin1647 Před 2 lety +2

    Very helpful video simple and direct to the point.

  • @aksamakbar1904
    @aksamakbar1904 Před 3 lety +2

    thanks for your digestible video tutorials 😊

  • @bvk1637
    @bvk1637 Před 3 lety

    Bro u'r da men! MANY THANKS!

  • @anasfasil
    @anasfasil Před 4 lety +8

    Your lessons are extremely high valued one.... It's worth more. Go ahead keep posting. thanks for your valuable time.

  • @kalimichael3994
    @kalimichael3994 Před 3 lety

    thank you sir I'm relieved

  • @masoodahmaddar1562
    @masoodahmaddar1562 Před 2 lety

    very well i understand well the way of your education....thanks

  • @wayando
    @wayando Před 2 lety +2

    Thanks alot for the lesson. I made use of this immediately ... I didn't know about the F4, I was editing the formulas one by one almost 600 times!

    • @arildk90
      @arildk90 Před rokem

      I think you can edit the top 2 functions instead also, then mark both before you drag down.

  • @priswanene4370
    @priswanene4370 Před rokem

    Thank you it works with me

  • @aphiwemjiwu2010
    @aphiwemjiwu2010 Před rokem

    Very helpful

  • @virtualwomentalks4856
    @virtualwomentalks4856 Před 2 lety

    it helped me a lot...TQ

  • @adammalak426
    @adammalak426 Před rokem

    Nice tutorial

  • @dudleyex3333
    @dudleyex3333 Před 2 lety +2

    i am doing a league table of wins and loses for each player in the league. if i type a W in a cell or an L in same cell, how do i count Wins

  • @TheHoshmanddeeba
    @TheHoshmanddeeba Před 4 lety +2

    nice presentation, really easy to follow and understand. Best Regards from Birmingham UK

  • @thelivingmiracle
    @thelivingmiracle Před 3 lety +1

    I have an excel question, I want to record the win/loss record of two mini golf players. How do I make a function that finds who has the lower score and adds a win to there win column. And adds the loss to the losing player?

  • @palaksh5564
    @palaksh5564 Před 4 lety +2

    Thank you

  • @imranomar207
    @imranomar207 Před 3 lety

    Nice video great explanation if c3 having exact 60 what happen?

    • @zueripat_btw
      @zueripat_btw Před 3 lety

      In this situation --> IF(c3>60, "True", "False") then it displays False because the value has to be greater than 60 but if you use --> IF(c3>=60, "True", "False" ) it displays True because the value of c3 is eqal or greater than 60.

  • @superjcool
    @superjcool Před 3 lety

    Im very confused im a student and im learning this. If the question says if it is higher then 100, do we use > or

    • @zueripat_btw
      @zueripat_btw Před 3 lety +1

      > means the value on the left is higher , < means the value on the right is higher, >= means that the value on the left is higher or the same as the value on the right and =, = means that both values are the same.

    • @m.m.432
      @m.m.432 Před 2 lety +1

      I was taught in elementary school to think of the symbols like an alligator's mouth....
      >°°,,]^^^,,]~~~
      ~~~[,,^^^[,,°°<
      This alligator is always hungry, so he always wants to eat the bigger number. Now, think : we have 10 apples and 20 apples. Does the alligator want to eat the 10, or the 20? 20, because alligators are greedy like that... so, the answer is:
      10 apples ~~~[,,^^^[,,°°< 20 apples
      10 < 20
      ten is less than 20
      BUT! ...if we reverse the numbers...
      20 > 10
      twenty is greater than 10
      It's the same greedy alligator, but which way does he face? Toward the bigger number.
      We still read the sentence from left to right, regardless of which way the alligator is facing.
      Let's throw in some algebra in there.
      x > 100
      x is greater than 100. therefore, x = 101 or more.
      100 < x
      100 is less than x. therefore, x = 101 or more.
      x < 100
      x is less than 100. therefore x = 99 or less.
      100 > x
      100 is greater than x. therefore x = 99 or less.
      ******
      Now, if > is greater than ("THIS" is greater than "that"), and if < is less than ("this" is less than "THAT"), then if we add an equal sign to it >= is "greater than or equal to" and

    • @superjcool
      @superjcool Před 2 lety

      @@m.m.432 hahaha 😅 your alittle too late, im done with 6th grade 😅😅😅, but thanks for giving an answer :)

    • @m.m.432
      @m.m.432 Před 2 lety +1

      @@superjcool you might be done with 6th grade, but does not the alligator imagery help you figure out which one to use? ;) I'm 44 years old, and I still think of the same tricks I learned in kindergarten, 6th grade, high school, and every trick since. "righty tighty, lefty loosey", "NEWS", "PEMDAS", "blow smoke in red oak", "leaves of three, leave it be"... every trick, no matter how childish, is worth learning and remembering IF it helps.

    • @superjcool
      @superjcool Před 2 lety

      @@m.m.432 it does help :), after reading alittle bit i started to understand

  • @draganvlavojinovic766
    @draganvlavojinovic766 Před 3 lety

    AAAAAAHh YA

  • @kihoonkang4236
    @kihoonkang4236 Před rokem

    "Achived"

  • @Khalid-rb5yz
    @Khalid-rb5yz Před 7 měsíci

    الله يهديك يا ست ابوها دخلتنا فطوفه

  • @russellhobkirk9270
    @russellhobkirk9270 Před rokem

    Or else you can do =IF(C3>60,"Goal Achieved","-",)

  • @derishastuart1477
    @derishastuart1477 Před 3 lety

    Z

  • @geraldbull9272
    @geraldbull9272 Před 4 měsíci

    Music is annoying.

  • @ukk9798
    @ukk9798 Před rokem

    Nice tutorial