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