Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

June 24, 2020



Learn how to use Excel’s IF Function in your reports.
Check the Excel Essentials Course:

We cover a few examples in this tutorial including:

1. Simple IF function (also with greater than or less than checks).
2. IF Formula together with AND logical test to decide outcome if more than one condition is met.
3. Nested IF formula (an IF inside another IF) to check for multiple criteria.
4. IF formula with OR function (to check if “either” condition is met and then decide the outcome).
5. We also take a look at using formulas (other calculations) inside the IF function and finally:
6. How to use symbols as the result of the IF formula

Your IF formula isn’t working? One of the main mistakes is the “else” argument. That’s the last argument inside the IF function. Make sure you haven’t forgotten to specify what should happen “if” the condition isn’t met. In case you have more than one condition, here’s the place to add the second “if” statement. An IF formula inside another IF formula is called a nested if function.

Download the workbook here:

Links to related videos:
Conditional formatting symbols:
Custom formatting symbols:
If Function with Partial text match:

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free

EXCEL RESOURCES I Recommend:

Time Stamps:
00:00 When to use the Excel IF function
00:35 When to use a Nested IF formula
00:55 Excel IF THEN formula
03:18 Excel IF formula with AND condition
05:05 Nested Excel IF formula
07:52 Excel IF formula with OR condition
09:17 Excel IF formula with threshold
11:22 Excel IF formula with symbols for result
14:29 Wrap-Up of different uses of Excel IF function

Get Office 365:
Microsoft Surface:

GEAR
Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:
Microphone:
Lights:

More resources on my Amazon page:

Let’s connect on social:
Instagram:
Twitter:
LinkedIn:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Nguồn: https://tokodewasa.net/

Xem thêm bài viết khác: https://tokodewasa.net/tong-hop/

All Comments

  • fantastic way to explain. great job

    T. Ch Hanuman Rao June 24, 2020 7:18 pm Reply
  • Hi mam i have create vlookup but I have same work order with different labour cost and I need to create next sheet with vlookup search and I want all labour cost with same project number..

    Syed Ib Ak June 24, 2020 7:18 pm Reply
  • Hi Guys..Need help with a formula…My Formula in Words 🙂 ! If the value in a cell(B6) in 'July 2020' sheet is greater than "0" copy/transfer certain data from "July 2020" to the next sheet ('August 2020(Obviously into multiple cells ) Hope someone can help me!

    Lorenzo Carolus June 24, 2020 7:18 pm Reply
  • That video saved my day hehe thank you so much leila much appreciated

    Phelipe Carmo June 24, 2020 7:18 pm Reply
  • Hello! Is there a way to use nested if in a filtered data?

    carole nisperos June 24, 2020 7:18 pm Reply
  • Thank you for nice explanation.
    I have one query on below formula,
    =IF(A3=A4&A3=A5,MAX(B3:B5),0)
    Or
    =IF(A3=A4=A5,MAX(B3:B5),0)

    Both are giving wrong results.
    Could you please suggest…

    Social Sathish Rao June 24, 2020 7:18 pm Reply
  • EXCELLENT Demo!!!!!!

    Braulio Ayala June 24, 2020 7:18 pm Reply
  • but what if you need it for true and false

    Aanya Charles June 24, 2020 7:18 pm Reply
  • Awesome. You are easy to listen to. Everything is very clear. If you also teach coding and webdesign… sign me up.

    seniscram June 24, 2020 7:18 pm Reply
  • hi madam, if numer also contain text for exmple, 10g, 300ml can we use if formula. i am trying to use but not working. i am using =IF(A1<10,"a","b"). everthing showing b. please reply madam thank you in advance

    Samir Awati June 24, 2020 7:18 pm Reply
  • Great video. Would you also be able to throw some light on how do you insert different scenarios like
    >1000<25000 – 10% discount
    >25000<39500 – 20% discount
    <39000 – 30% discount
    With IF(AND conditions

    Avinash Gupta June 24, 2020 7:18 pm Reply
  • Dears: Could you please help on this (How to calculate Cumulative sum for set of cells when we have change(s) in another cell(s), mohamed.naji@live.com Thank You

    Mohamed Naji June 24, 2020 7:18 pm Reply
  • Leila, your videos are so clear and present amazing Excel capabilities that I haven't met in my 20 years with Excel. I've not yet finished this video, but I'm wondering why you didn't give C2 a name instead of referencing it as $C$2. I like names because they make formulas easier to read when I come back later and wonder what I was doing – such as "If (YTDRevenue > etc. Probably you discuss names in other videos that I haven't yet watched.

    Pam Cadd June 24, 2020 7:18 pm Reply
  • Hi I need to add one value to multiple time when the count is increase. Can u upload one video please

    Vinotha Narms June 24, 2020 7:18 pm Reply
  • I had one query mam, if i am copy pasting data from a webpage which has images and logos and then i use paste special in excel then after that sorting of the data becomes troublesome, so do you have any videos related to it?? It will be of great help to understand such functionality

    Saugata Santra June 24, 2020 7:18 pm Reply
  • Very nice trick,
    I have a question,
    I extracts login/logout report of all staff and I need a code or trick to show or filter the first login and last logout record.

    Khowaja Ghulam Sakhi SEDIQY June 24, 2020 7:18 pm Reply
  • Thank you so much for making this confusing function comprehensible! The manner in which you speak is also very pleasant to the ear whilst learning!

    Elso02 June 24, 2020 7:18 pm Reply
  • Thank You! This is exactly what i needed.

    Nick H June 24, 2020 7:18 pm Reply
  • Thank you for sharing

    Wunlapar Hanvittayanukool June 24, 2020 7:18 pm Reply
  • I'm glad I found you on YouTube and I've subscribed. Thanks so much!

    Lucky Rathore June 24, 2020 7:18 pm Reply
  • Excellent…
    👏👏

    Lc1975 June 24, 2020 7:18 pm Reply
  • HLO MAM HOW R U I WANT YOUR HELP IN EXCEL PROBLEM CAN YOU HELP ME . I HAVE VALUR BATCH NO. MFG DATE DATE EXP DATE MRP. PRODUCT NAME I WANT ALL OF THESE WORDS IN B1:B5 WHEN I WRITE A VALUE IN CELL A1

    Gaurav Kaith June 24, 2020 7:18 pm Reply
  • You're simply awesome

    CMA Pradeep Kumar June 24, 2020 7:18 pm Reply
  • Actually am new to excel world however your explanations makes difference as a result I like to learn more is any opportunity to help me

    Tee Diamond June 24, 2020 7:18 pm Reply
  • Many thanks,

    Tee Diamond June 24, 2020 7:18 pm Reply
  • IF(((B5>$D$2)*(B5<$D$3)),$C$3,"")- I used this formula for >& <(15000 & 20000) example in your video, i still the same answer, Wanted to know whether this approach is robust or not?

    Saurabh Ganguly June 24, 2020 7:18 pm Reply
  • To the point…Thanks for the wonderful tutorial👍👍

    SWAPNIL PATIL June 24, 2020 7:18 pm Reply
  • I am using Excel 365 and I monitor my shares via the Shares button. How can I change it to refresh automatically

    David Drew June 24, 2020 7:18 pm Reply
  • You are awesome, incomparable!

    Bimal Panchal June 24, 2020 7:18 pm Reply
  • Excellent tutorial. Very easy to follow

    Phuc Le June 24, 2020 7:18 pm Reply
  • Very good!

    Manuel Barros June 24, 2020 7:18 pm Reply
  • I'm tired as hell, I know everything you showed in this video as I have used the "If" function extensively, and I still got to watch it to the end with all the attention I could manage to gather.
    Thank you Leila. Stay safe.

    John Philippatos June 24, 2020 7:18 pm Reply
  • Thanks so much for the videos you post…you have helped me so much in advancing my skills in excel!!!!!!🙏🙏🙏🙏

    lisadeniney405 June 24, 2020 7:18 pm Reply
  • IF( YOU watch the video, "on $ CORONA DAYS $ ", "say Hi and $ Click Thumbs Up $ ")

    ALi URMU June 24, 2020 7:18 pm Reply
  • Hi Leila, how to club below 3 formula's into one formula?
    =IF(A1="S",B1*-1,B1)
    =IF(A1="L", C1*-1,C1)
    =IF(B1=0,C1,B1)

    Josy Joy June 24, 2020 7:18 pm Reply
  • I'm starting from zero here can you please tell me what do you mean by fixing it by pressing F4 and why is it necessary.

    Baatish June 24, 2020 7:18 pm Reply
  • Your explanation is too good … to be more honest now I have understood use of if(and .. if(or …. thanks a lot Mam

    VENKAT IYER June 24, 2020 7:18 pm Reply
  • How to use IF based on cell color with auto update without refreshing?

    Hanson Tan June 24, 2020 7:18 pm Reply
  • Thank you! Very useful in answering exam questions

    Kasonde Lwao June 24, 2020 7:18 pm Reply
  • Hi ma'am
    Thanks for teaching us.
    I have a question. Could you please tell us that what's the difference between Nested if and And funtion? Both are the same firmula. Please help.

    vinit gupta June 24, 2020 7:18 pm Reply
  • Excellent tutorial. It seems that much, if not all, of this information can be used in LibreOffice Calc. I will eventually give it a try. This is the second video of yours I have watched. I am sure they all deserve a "Thumbs UP". Thanks.

    DrinkingStar June 24, 2020 7:18 pm Reply
  • Thank I was searching for it but you should make quick video and you should choose a good screen recorder and good video compressor

    Mahedi Ferdous June 24, 2020 7:18 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *