 # Excel If Formula – Nested If AND OR Functions

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:

Tag: if excel formula, excel, if formula, nested if function, and function, or function

Xem thêm: https://taichinh4u.net/category/review

Nguồn: https://taichinh4u.net

Rate this post

Originally posted 2021-03-22 02:27:48. #### 37 bình luận

1. Hi, How can I put these multiple formula into one?

If A2=False and B2 = Disabled = "Completely Deactivated"

If A2=False and B2 = #N/A = "Completely Deactivated"

If A2=False and B2 = Active = "Completely Deactivated"

If A2=True and B2=Disabled = "Temporary Deactivated"

If A2 = True and B2 = #/NA = "Temporary Deactivated"

If A2=True and B2=Active = "Active"

2. Omg this guy is everything sensei😼

3. Thank you! You are the best.

4. I need some help with a similar formula except sometimes one piece of data is missing so I need it to assume false.

5. Awesome! Thank you so much. Really like the way you built it from the basis!

6. Good

7. 11:43 for formula less than

8. You are the best brother.How i wish you would also teach data base.

9. Hello good evening I need ur small help if u have time to help me plz give me ur what's up no

10. Explained really well in 20 mins, I was stuck in the IF Function and the Nested IF Functions, u saved me big time. Thanks for doing that, greatly appreciated.

11. My dude What can you not do?

12. So, so good… Many, many thanks, great job!

13. bruh what is it that you don't teach.

14. Thank you bro

15. I was on one question off and on for 6 hours and watching and reading lots. 9 minutes into this video, and I have the answer. Thank you, new sub.

16. WHY THIS GUY IS GOOD AT EVERYTHING ?!!!

17. By watching this video I was able to determine that I needed an “and” formula and not an “if” formula. This guy is amazing. Thank you for the tutorial.

18. It is very enjoyable video and I am glad to find this Nesting if, or and function. Thank you very much.😁😁😁

19. I'm trying to check if a field's value is 0 then I keep that zero. If it's not equal to 0 then it should run the networkdays() formula. However, it's failing all the time. I've changed the format of the field from general, to number, to text but it keeps failing. What could I possibly be doing wrong? Thx.

20. This is a nice and easy tutorial. Thanks.

21. Hello. I am making a scientific calculator in excel.
https://youtu.be/ZStzj9JUfCk

22. i have one one condition

less than 1 year is 0, greatre than 1 and less than 3 is 7, greater than 3 and less than 5 is 14, greater than 5 is 14. how i can do by this if formula. can you please help me on this to build with if formula

23. Thanks

24. 22/03/2021 tại 2:27 sáng

Nice video for using the conditions

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

26. its a miracle

27. 22/03/2021 tại 2:27 sáng

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.

28. wt if i want it to check 3 options and if not another word not true or false

29. 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

30. Thank you

31. 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!!!!!

33. 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

34. 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!

35. Probably the best video on AND/IF/OR statements on Excel – 20 minutes well spent, thank you for producing this video.

36. 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!

37. 22/03/2021 tại 2:27 sáng

You’re prolific with your content man. What keeps you going at this pace? Thanks for putting it out.