Excel If Formula - Nested If AND OR Functions
HTML-код
- Опубликовано: 4 июн 2018
- 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.
Excel Tutorial For Beginners: • Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
________________________________________
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
Excel Vlookup Function:
• How To Use The VlookUp...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
Multiple Dependent Drop Down Lists:
• How To Create Multiple...
How To Show & Hide Formulas:
• How To Show and Hide F...
______________________________________
Relative & Absolute Cell References:
• How To Use Relative & ...
Lock Cells and Protect Sheets In Excel:
• How To Lock Individual...
Excel Interactive Checklist:
• Interactive Checklist ...
Excel Pivot Tables:
• Intro to Pivot Tables,...
______________________________________
RUclips Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tutor.net/algebra-f...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections
Final Exams and Video Playlists: www.video-tutor.net/
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.
WHY THIS GUY IS GOOD AT EVERYTHING ?!!!
My instant thought wen I saw this video😭👍🏻
Yoooooo!!! It's the guy whom I watched videos while I was studying my IGCSE. So good to hear your voice man ☺️❤️
Same
Organic Chemistry Tutor! You are the best! From teaching sciences stuff to excel and many more. I can say that you can teach everything.
You’re prolific with your content man. What keeps you going at this pace? Thanks for putting it out.
You nailed it bro...keep uploading new videos..love from Assam (India)
So, so good... Many, many thanks, great job!
It is very enjoyable video and I am glad to find this Nesting if, or and function. Thank you very much.😁😁😁
i love all the things you teach and get to know more betters with you
Props to you man, thank you so much for all the help!
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.
You are a teacher. Keep up the good work
Thank you very much, been at this for a long while and couldn't figure it out, you saved me
This is a nice and easy tutorial. Thanks.
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.
Yes! I was scarching such a video. Practical is better than discription. Many many thanks.
you saved my life man.thank u soo much.
Bro!! do you teach everything!!!
thank you very much for this video, I have just understood these points after watching it so thanks
Great video. Really helped me look smart at work hahaha
Thank you I really learned a lot from this video
Such an insightful video. Thanks !
Thank you for another awesome video👏
This is a wonderful video.
I have learnt a lot.
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.
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!!!!!
Thank you! You are the best.
Nice video for using the conditions
i always stumble across this guy no matter the subject or year of uni lol
Awesome! Thank you so much. Really like the way you built it from the basis!
Nc! Very easy to follow the instructions ❤️
Really help! thank you for sharing this. Really appreciate it :)
Omg this guy is everything sensei😼
bruhhh u teach excel stuff as well😂😂, u are a god
You are the best brother.How i wish you would also teach data base.
Great job thank you so much
Thanks Julio, great Vid!
Hey organic! Your videos have been a huge help in my journey with self learning, and im now trying excel for a small business that i work with(its really small) and i want to type the "if" function like =if(a1
Is the business big now
Thank you bro
Thank you so much 😊
Thank you so much!
Thank you
Great content!
I love you!!!!!!! Thanks so much
Insightful
I did exactly how he did it but excel says its wrong formula, end me up doing it several times still the same
I didn't know you had videos on excel. Your maths videos really helped me ☺️
thank you bro
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.
thank you
Thanks
Thanks Mark Wallberg
Thank youuuu
its a miracle
Thank yooooooooooooo
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!
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
please put time stamps in your videos in future. Otherwise great content!
good sir
Good
I need some help with a similar formula except sometimes one piece of data is missing so I need it to assume false.
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.
1 question, why do you use quotation marks for yes and no but not for true and false?
wt if i want it to check 3 options and if not another word not true or false
I need a function from a number three checking in one cell . In that cell contain 7:20 I need if >7:00,1 , and if that cell 4,0 please help thanks
I love you
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
i thought you only do maths and chemistry videos
Is the titel of the video not misleading? I was hoping to see the different function If, And, Or combined in one formula.... or am I wrong?
I'm trying to check the entry from a cell that could have 3 values. if c then value should be cell k2/100, if m then value should be k2/1000, if ea then value should be k2/1. =iF(l2=c, [k2/100], IF(l2=m, [k2/1000], IF(l2=ea, [k2/1]))) what am I doing wrong?
how do you use the If function for multiple reasoning. Like if the value is 1 it will result to 1000, then 2 should result to 2000, but if it is more than 2 it should return as 2000.
If(A1
Hello. Please help. Have problems with the formula. This is my project. In Column A I have 4 checkbox. Column B I have 4students. Column C I have current rank with a drop arrow showing this of all the rank in Taekwondo. In column D I have new rank with a drop list of all the rank in Taekwondo. I need help with a formula that when I check the box the new rank show. Ranks are ascending on my list. And last how do I save it for future record. Thank you in advance.
i need help. how do i make it so that "if this box says male, then put 1, however if it says female, put 2 and if its neither put 3"
i cant figure it out, i put =IF(AND(C5="male"),"1",if(C5="female"),"2","0")) but it doesn't work ,it just highlights "female" and does an error
edit: figured it out and somehow this works even though i don't understand the brackets at all:
=IF(AND(C5="male"),"1",IF(C5="female","2",3))
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,"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
Where is 0.15 come from?
Anyone know how to write out the following? I want to round up the number of a specific cell to the nearest 100 (not bothering with decimal points), then multiply that by 0.5.
11:43 for formula less than
Basically I am helping a couple getting divorced. If the income comes from certain sources, then they split the money, if it doesn't then it stays with one person. I every time I put in the formula like this, =if(OR(b2="rent",b2="interest"), b3/2, 0) -- it doesn't work for the second stipulation. I have also tried putting it in with just the OR and excel doesn't let me. Can anyone help?
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"
U cant have many functions in one cell, only nested functions. I guess this could be a solution for u: u use each one of this formula in one column, then u concatenate all the column results in one column (using concatenate function).
Ok
bro got excel tutorials too, wtf
My dude What can you not do?
you sound like eminem and mark walberg
lol so hard :(
bruh what is it that you don't teach.
I didn't find this practical or well organized as well as no real value added other than it was short. Sorry.
You're making things more complex and hard to understand. Lol
Ok