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
Originally posted 2021-03-22 02:27:48.
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"
Omg this guy is everything sensei😼
Thank you! You are the best.
I need some help with a similar formula except sometimes one piece of data is missing so I need it to assume false.
Awesome! Thank you so much. Really like the way you built it from the basis!
Good
11:43 for formula less than
You are the best brother.How i wish you would also teach data base.
Hello good evening I need ur small help if u have time to help me plz give me ur what's up no
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.
My dude What can you not do?
So, so good… Many, many thanks, great job!
bruh what is it that you don't teach.
Thank you bro
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.
WHY THIS GUY IS GOOD AT EVERYTHING ?!!!
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.
It is very enjoyable video and I am glad to find this Nesting if, or and function. Thank you very much.😁😁😁
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.
This is a nice and easy tutorial. Thanks.
Hello. I am making a scientific calculator in excel.
https://youtu.be/ZStzj9JUfCk
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
Thanks
Nice video for using the conditions
bruhhh u teach excel stuff as well😂😂, u are a god
its a miracle
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.
wt if i want it to check 3 options and if not another word not true or false
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
Thank you
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!!!!!
You nailed it bro…keep uploading new videos..love from Assam (India)
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
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!
Probably the best video on AND/IF/OR statements on Excel – 20 minutes well spent, thank you for producing this video.
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!
You’re prolific with your content man. What keeps you going at this pace? Thanks for putting it out.