Excel If Formula – Nested If AND OR Functions

June 29, 2020



This excel video tutorial provides a basic introduction into the IF Formula. It explains how to use the if function when it’s nested with the AND function as well as the OR function.

My Website:
Patreon Donations:
Amazon Store:

Subscribe:

Excel Tutorial For Beginners:

Top 10 Excel Formulas:

Top 30 Excel Tips, Tricks, & Shortcuts:

How To Use VLookUp:

Pivot Tables:

Excel Tutorial Playlist:

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

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

All Comments

  • bruhhh u teach excel stuff as well😂😂, u are a god

    James Fung June 29, 2020 2:03 pm Reply
  • just a comment; on 15:07, you said greater than but typed less than.

    Joe Sat June 29, 2020 2:03 pm Reply
  • its a miracle

    Samira Baghban June 29, 2020 2:03 pm Reply
  • Does this work with data validation? I’m trying to input in logical test quoted data from validated data, it doesn’t seem to work.

    D Brizuela WimFoca CuberKat June 29, 2020 2:03 pm Reply
  • wt if i want it to check 3 options and if not another word not true or false

    Jude Paul June 29, 2020 2:03 pm Reply
  • how many condtions can a and statement have i hvae to copmare values in 5 columns and if even one of the mis zero state fail but it never does it

    SiGHT SMaSH June 29, 2020 2:03 pm Reply
  • Thank you

    Cyrus Hackett June 29, 2020 2:03 pm Reply
  • Thank you so much for this viedo! I am currently in an analytics class and do not know these formulas that I have to do. Thank you for sharing!!!!!

    John Linder June 29, 2020 2:03 pm Reply
  • You nailed it bro…keep uploading new videos..love from Assam (India)

    Keshab Newar June 29, 2020 2:03 pm Reply
  • Hi and thanks for posting the video. Does this only work with words i.e. YES / NO commands or can it be used to write numerical formulas?
    I'm trying to get a cell to either display £0.00 or work out an amount of money based on whether the value is above or below this amount (see formula below)

    =IF(AND(B41<$A$40),"£0.00",or(B41>=$A$40,"B41-$A$40*0.09"))

    basically if B41 is below A40 then the formula should display £0.00. But if B41 is >= A40 then take B41 and minus A40 and then calculate 9%
    if anyone can show mw what ive done wrong it would be much appreciated

    Harpal Singh June 29, 2020 2:03 pm Reply
  • Learned significantly more from this 20 minute video than several 2 hour long lectures with my prof this semester. Thank you for the cram material!

    Brie Sunshine June 29, 2020 2:03 pm Reply
  • Probably the best video on AND/IF/OR statements on Excel – 20 minutes well spent, thank you for producing this video.

    SAM O June 29, 2020 2:03 pm Reply
  • Hi! your videos are extremely helpful. do you think you can make more videos on calculus 3 multivariable calculus. especially vector valued functions and vectors in the plane, space, and 3D. including finding the first derivative of vector valued functions and tangent vectors? Thank You!

    ohsnapitsifu211 June 29, 2020 2:03 pm Reply
  • You’re prolific with your content man. What keeps you going at this pace? Thanks for putting it out.

    TerribleMachinations June 29, 2020 2:03 pm Reply

Leave a Reply

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