Video není dostupné.
Omlouváme se.
Excel If Formula - Nested If AND OR Functions
Vložit
- čas přidán 4. 06. 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,...
______________________________________
CZcams Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tuto...
Final Exams and Video Playlists:
www.video-tuto...
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.
Organic Chemistry Tutor! You are the best! From teaching sciences stuff to excel and many more. I can say that you can teach everything.
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
You are a teacher. Keep up the good work
You’re prolific with your content man. What keeps you going at this pace? Thanks for putting it out.
i love all the things you teach and get to know more betters with you
Great video. Really helped me look smart at work hahaha
Yes! I was scarching such a video. Practical is better than discription. Many many thanks.
Props to you man, thank you so much for all the help!
Thank you very much, been at this for a long while and couldn't figure it out, you saved me
you saved my life man.thank u soo much.
thank you very much for this video, I have just understood these points after watching it so thanks
Bro!! do you teach everything!!!
Such an insightful video. Thanks !
I love you!!!!!!! Thanks so much
So, so good... Many, many thanks, great job!
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.
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.
i always stumble across this guy no matter the subject or year of uni lol
You nailed it bro...keep uploading new videos..love from Assam (India)
This is a wonderful video.
I have learnt a lot.
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!!!!!
It is very enjoyable video and I am glad to find this Nesting if, or and function. Thank you very much.😁😁😁
Thank you I really learned a lot from this video
Thanks Julio, great Vid!
Thank you for another awesome video👏
Nice video for using the conditions
Thank you! You are the best.
This is a nice and easy tutorial. Thanks.
You are the best brother.How i wish you would also teach data base.
Omg this guy is everything sensei😼
Really help! thank you for sharing this. Really appreciate it :)
Nc! Very easy to follow the instructions ❤️
Thank you so much!
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.
Great job thank you so much
Great content!
Thank you so much 😊
Thank you bro
bruhhh u teach excel stuff as well😂😂, u are a god
thank you
I did exactly how he did it but excel says its wrong formula, end me up doing it several times still the same
Thanks Mark Wallberg
Insightful
I didn't know you had videos on excel. Your maths videos really helped me ☺️
thank you bro
Thank youuuu
please put time stamps in your videos in future. Otherwise great content!
Thank yooooooooooooo
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
Awesome! Thank you so much. Really like the way you built it from the basis!
Thank you
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.
Thanks
1 question, why do you use quotation marks for yes and no but not for true and false?
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?
good sir
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!
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?
Good
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.
its a miracle
I need some help with a similar formula except sometimes one piece of data is missing so I need it to assume 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
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))
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
i thought you only do maths and chemistry videos
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
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
Where is 0.15 come from?
wt if i want it to check 3 options and if not another word not true or false
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).
11:43 for formula less than
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.
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
Ok
bro got excel tutorials too, wtf
you sound like eminem and mark walberg
My dude What can you not do?
I didn't find this practical or well organized as well as no real value added other than it was short. Sorry.
lol so hard :(
bruh what is it that you don't teach.
You're making things more complex and hard to understand. Lol
Ok