Your tutorials are great! I didn't quite understand what you were saying at the end of the "Nested Excel IF Formulas" section at around 7:50 ish when you were saying that Excel will "leave the formula" as soon as it recognizes a met condition?? I mean I think I understand what you meant but how would you have written out any of the formulas with multiple logical tests where, as you were writing it, it recognized a met condition before you finished writing it?
As a computer trainer for over 30 years, I'd have to say you are by far the best online video tutorial creator that's on RUclips. Every single one of your videos is very clear and easy to understand and the fact that you provide the files for people to use/practice with makes your videos truly exceptional. Thank you!
Thank you Leila, I have watched other people's Excel Video's but tend to get lost in the technical jargon, however, since I found your video's, I am soaring ahead due to your no nonsense, easy to learn approach to each and every part of the exercise, and they guarantee success every time. I won't watch anyone else's video's anymore because your video lectures are easily miles ahead of the field and as a consequence I have now subscribed and will recommend you to all my family and friends.
As an instructor myself, I appreciate your skills. This video and the several others I have watched cover the material efficiently, without breaking the material down to a painfully basic level. There is no magic amount of detail for every audience as their diverse skill set is the uncontrollable variable, but you are nailing it for my needs. Thank you, and keep them coming!
Excel is one of those programs where most people have a basic knowledge, and most people just assume you know how to use, I had a coworker who had a background in Accounting, and she could run laps around me in Excel and I was just scratching my head and asking "could you do it one more time, but slower?" having Leila explain it makes it so much easier to learn. I wish there were more people like Leila who are willing to help out in Excel.
By far the best and correct tutorial, I have did excel 11 years ago but forgot a lot and many videos ppl use to feed their ego and showing ppl incorrect ways to do it and this is how I remember. Being taught at Tafe. Full formula no shortcuts no fancy ways of explaining. Perfect and to the point. Calm voice, clear instructions and best of clear voice and at perfect tempo. Any faster talk and you could miss half the talk. Awesome
After searching for an hour how to use "if" multiple times: you are the only one come up with this most accurate and proper formula. Thank you so much Leila from the bottom of my heart for this well prepared tutorial.
I am a senior Excel user transferred from Lotus 1-2-3 for over 30 years, now a retiree. Nested IF was my headache to write a lengthy and complex formula. It’s very hard to debug or modify when the conditions changed. Hence, I used an alternative way to solve this headache. I split the nested if into one to one comparison if formula. If the comparison is true, then give 1 at the same row right to the raw data matrix, else give 0. Therefore, I will get several 1s or 0s in the computing cells. Then, multiply or add the results in the computing cells, AND is equivalent to “multiply” and OR is equivalent to “add”. This will simplify the Nested IF formula and make it easier to be maintained.
Wow, girl, you are very good. Thank you very much. You explained it very well. You remind me of my maths tutor who taught me maths so well that I passed with an A+ even though I used to suck so badly at maths in the past. Keep the good work, please. The world needs great teachers like you.
Thank you! After two days of googling and youtubing, you're the first person/video to make sense of nested IF forumulae. please post more of the more complicated nested IF/AND/OR, etc statements. you're a natural teacher.
I just got my associates and working towards my cs bachelor's. I have been importing excel sheets into mysql because i was unaware you could use elif statements in excel. This saves so much time and makes it easier to cleanse and organize. Best randomly suggested video ive ever watched.
You present information in a polished but not over-produced way. It's less like teaching ideas and concepts and more like a confident professional passing on information to peers conversationally. You have a great combination of skills and attributes that allows the viewer engage almost like you are speaking with them personally. I'm subscribed, thank you.
OMG If it wasn't for this video I don't think that I would have ever figured out how to configure multiple IF functions using greater and less than symbols! I searched for several examples and this was by far the best one. It was easy to follow and understand! I am definetly a subscriber now!
Hi Leila Your explanations and exolaining technique is brilliant. A real nice work. Keep up the fabulous job. It is really helpful for so many users like me. Thanks again for the brilliant explanation.
I'm tired as hell, I know everything you showed in this video as I have used the "If" function extensively, and I still got to watch it to the end with all the attention I could manage to gather. Thank you Leila. Stay safe.
You don't rush while explaining. That way concepts inside the minds of students sink very easily and not in a garbled manner. Your examples with each step explained so clearly further help students like is understand better. Thanks a lot.
Mme Leila Gharani ... I like and try to follow all of your videos. If I have any problem on how to use the functions of Excel, I directly looking for your videos.. Thank you with all my heart. You are the best with all my respect for the other professors.
Besides learning how to correctly use conditional functions in formulas, I learned how to structure my table of requirements. Once I followed your table structure, the logic easily fell into place. Thank you and may God's face shine on you...
You have helped me upskill!!! Thank you so very much for explaining concepts that I just couldn't get before your videos... you are much appreciated lady!!!
so glad that I've found this. I doing a workbook on Body Mass Index of a population (1,800+ people) with multiple factors aside from Age, Height, and Weight, such as Age Groups, Waist and wrist circumference, and Body Frame values.
Assume that you have the value in cell B17 and you insert this function in C17 cell =IF(B171000,B17=25000,B1739000,30%)))) This function will do what you have requested
Thanx Leila you are a great teacher I'll recommend you to my friends and families who are struggling with excel formula u make it very simple,keep up...
This lady is phenomenal, fantastic at explaining everything in detail. I am super happy and excited about taking all these courses. Thank you so much Leila, you are fantastic !!
I love how you’re conveying your information in a mathematical way , which helps in grasping not just memorizing, i rarely comment in youtube but i have to this time !
Leila, your videos are so clear and present amazing Excel capabilities that I haven't met in my 20 years with Excel. I've not yet finished this video, but I'm wondering why you didn't give C2 a name instead of referencing it as $C$2. I like names because they make formulas easier to read when I come back later and wonder what I was doing - such as "If (YTDRevenue > etc. Probably you discuss names in other videos that I haven't yet watched.
You explaining method is too good, I have through lots of channel but your way of explaining is too simple and impactful. From today u are my Excel GURU
Great videos. For the third example ( 7:12 ), an alternate slightly simpler method that doesn't require the AND is this: =IF(B9>=$E$3,”Exceptional”,IF(B9>$E$2,”Good”,B9)) instead of: =IF(AND(B9>$E$2,B9=$E$3,”Exceptional”,B9)) This also works well when there are many ranges (e.g., stratifications with many buckets) since you can just continue to daisy chain the IF statements.
You are WONDERFUL!!!!! Everything in your videos are perfect. Your voice, words you choose, speed, explanations, visuals, demeanor, just everything! Thank you so much for all of your hard work, I really appreciate you!
This is my first video looking up how to use the if/or function, your examples are great and the explanations are very clear. Thanks for delivering such a clear instructions, you got another subscriber.
Thank you so much Leila for this video. I have been working on something that was disturbing me as it involved a nine scale Risk Rating. With this video I have been able to pull it off. Thank you so much.
Nice explanation. Instead of using OR for the logical test of the +- 10% Threshold (10:40) you can work with absolute numbers: =IF(ABS(B23/C23-1)>10%...
Thankyou so much for explaining this, really helpful (ive never had this explained to me). I nearly got it to work but like you mention at 7:40 in the video, excel understands the first part of the formula as the condition is true. However when the condition is not true it is NOT evaluating the second part of the formula (never mind). if anyone sees this and can understand what im trying to do and they can see my mistake, I would be grateful for the answer =IF(AND(B41=$A$40,"B41-$A$40/100*9")) Basically if cell B41 is less than A40 then enter £0.00 but if cell B41 is > or = A40 then take B41 and minus A40 and then times by 9%
I've watched several tutorials on Excel by other instructors. In my opinion, you are by far the best! Thank you for sharing your knowledge in such a clear and understandable way.
My teacher sent this since we are in quarantine and it is the best thing he did because this is perhaps one of the greatest if not the greatest excel tutorial a human created. You got a sub and a like👏👏👏👏👏👏👏😁😁😉😉😊😊
Hi Leila you provided free education which help to learn detail. Thanks for the information and time you spend to create the free education video. i really appreciate your knowledge sharing :)
Just found your video this morning and I think it has saved my life - or at least my sanity! Thank you so much! I look forward to watching your others and learning how to not wreck my entire day with frustration! :-D
Good afternoon. I am working on my L2 Excel at college and the nested functions are a sticking point. I understand the process but not the nuances. This is a real help. Thank you.
Thank you very much, Leila! I'm using the compound logic function for phone numbers in my P.O. spreadsheet. Depending on the supplier entered, their phone number appears in the corresponding cell! It's a game changer!
Want to follow along? Download the file I used here 👉 pages.xelplus.com/if-function-file
=F2*G2, IF(H2=0,"5") how do i get this to work so that my value is never 0?
@@nicolezee950you are giving wrong equation
Your tutorials are great! I didn't quite understand what you were saying at the end of the "Nested Excel IF Formulas" section at around 7:50 ish when you were saying that Excel will "leave the formula" as soon as it recognizes a met condition?? I mean I think I understand what you meant but how would you have written out any of the formulas with multiple logical tests where, as you were writing it, it recognized a met condition before you finished writing it?
As a computer trainer for over 30 years, I'd have to say you are by far the best online video tutorial creator that's on RUclips. Every single one of your videos is very clear and easy to understand and the fact that you provide the files for people to use/practice with makes your videos truly exceptional. Thank you!
Thank you Leila, I have watched other people's Excel Video's but tend to get lost in the technical jargon, however, since I found your video's, I am soaring ahead due to your no nonsense, easy to learn approach to each and every part of the exercise, and they guarantee success every time. I won't watch anyone else's video's anymore because your video lectures are easily miles ahead of the field and as a consequence I have now subscribed and will recommend you to all my family and friends.
Wonderful! It's great to have you here.
As an instructor myself, I appreciate your skills. This video and the several others I have watched cover the material efficiently, without breaking the material down to a painfully basic level. There is no magic amount of detail for every audience as their diverse skill set is the uncontrollable variable, but you are nailing it for my needs. Thank you, and keep them coming!
Thanks Jim! I'm glad you like the videos.
Excel is one of those programs where most people have a basic knowledge, and most people just assume you know how to use, I had a coworker who had a background in Accounting, and she could run laps around me in Excel and I was just scratching my head and asking "could you do it one more time, but slower?" having Leila explain it makes it so much easier to learn. I wish there were more people like Leila who are willing to help out in Excel.
I used to be one of those people ... until I realized there is much more to learn :) I'm happy the tutorials are helpful for you. Keep learning!
By far the best and correct tutorial, I have did excel 11 years ago but forgot a lot and many videos ppl use to feed their ego and showing ppl incorrect ways to do it and this is how I remember. Being taught at Tafe. Full formula no shortcuts no fancy ways of explaining. Perfect and to the point. Calm voice, clear instructions and best of clear voice and at perfect tempo. Any faster talk and you could miss half the talk. Awesome
After searching for an hour how to use "if" multiple times: you are the only one come up with this most accurate and proper formula. Thank you so much Leila from the bottom of my heart for this well prepared tutorial.
You're very welcome. Glad the tutorial is helpful.
Leila, you have the best Excel tutorials I've found on RUclips. By far. Clear, concise, excellent examples. Thanks so much!
Not because she is female ...riiiighhhtt
I am a senior Excel user transferred from Lotus 1-2-3 for over 30 years, now a retiree. Nested IF was my headache to write a lengthy and complex formula. It’s very hard to debug or modify when the conditions changed. Hence, I used an alternative way to solve this headache. I split the nested if into one to one comparison if formula. If the comparison is true, then give 1 at the same row right to the raw data matrix, else give 0. Therefore, I will get several 1s or 0s in the computing cells. Then, multiply or add the results in the computing cells, AND is equivalent to “multiply” and OR is equivalent to “add”. This will simplify the Nested IF formula and make it easier to be maintained.
Wow, girl, you are very good. Thank you very much. You explained it very well. You remind me of my maths tutor who taught me maths so well that I passed with an A+ even though I used to suck so badly at maths in the past. Keep the good work, please. The world needs great teachers like you.
Ohhh thank you Su Sue! That means a lot! I'm very happy you find the explanation easy to follow :)
You are very good explained so thank you.
@@LeilaGharani Thanks you are so good. your explanation is very easy. Thanks a lot again
28iejhd6ffiffffcfffrrŕrfFFFdded
S
Thank you! After two days of googling and youtubing, you're the first person/video to make sense of nested IF forumulae. please post more of the more complicated nested IF/AND/OR, etc statements. you're a natural teacher.
Glad it was helpful!
Honestly I have never understand if function like this before even after my Two months class.. God bless you for this wonderful teaching
I'm glad I could help with that :)
Astonishing, isn't it?
Leila is a gem, really making an impact for millions of Excel users.
I just got my associates and working towards my cs bachelor's. I have been importing excel sheets into mysql because i was unaware you could use elif statements in excel. This saves so much time and makes it easier to cleanse and organize. Best randomly suggested video ive ever watched.
That's great!
You present information in a polished but not over-produced way. It's less like teaching ideas and concepts and more like a confident professional passing on information to peers conversationally. You have a great combination of skills and attributes that allows the viewer engage almost like you are speaking with them personally. I'm subscribed, thank you.
That's very kind! Thank you.
Since discovering your channel I've improved my excel skills by a loooot. Thank you!
This is 1000x better than a course I paid for. I'm glad I found you on RUclips and I've subscribed. Thanks so much!
I want to be able to run .30 to 1 on excel, please how can I do that ?
OMG If it wasn't for this video I don't think that I would have ever figured out how to configure multiple IF functions using greater and less than symbols! I searched for several examples and this was by far the best one. It was easy to follow and understand! I am definetly a subscriber now!
Great to hear!
Hi Leila
Your explanations and exolaining technique is brilliant. A real nice work. Keep up the fabulous job. It is really helpful for so many users like me. Thanks again for the brilliant explanation.
کانال های کود را فراموش نکنید قربان دستان پر مهر تان.........
I'm tired as hell, I know everything you showed in this video as I have used the "If" function extensively, and I still got to watch it to the end with all the attention I could manage to gather.
Thank you Leila. Stay safe.
Thanks for watching John.
This is much better than the college course that I paid for! Thank you! plus, you have a very calming voice.
Thank you!
It is great learning experience with you
@@LeilaGharani mam you teaches excellent
You don't rush while explaining. That way concepts inside the minds of students sink very easily and not in a garbled manner. Your examples with each step explained so clearly further help students like is understand better. Thanks a lot.
You deserve a lot more than just 76k subs. Hopefully, all good things comes to you. Thank you leila.
Now check her subs :). Your wish has worked pretty well.
729K ❤️
902k subs
@@danelleforbes5771 950k subs
998k
It's always a pleasure listening to you. You are Sandra Bullock of ExcelSheet. Thank you so much for sharing such precious knowledge!
That's very kind! Thank you Pankaj :)
You are the best Excel tutor ever..... Keep it up. And thank you so much for everything.
Mme Leila Gharani ... I like and try to follow all of your videos. If I have any problem on how to use the functions of Excel, I directly looking for your videos.. Thank you with all my heart. You are the best with all my respect for the other professors.
Wow, thank you very much!
Besides learning how to correctly use conditional functions in formulas, I learned how to structure my table of requirements. Once I followed your table structure, the logic easily fell into place. Thank you and may God's face shine on you...
¡Gracias!
outstanding demonstration..Thanks a lot..Highly Recommended
Mind blowing clear explanation
You have helped me upskill!!! Thank you so very much for explaining concepts that I just couldn't get before your videos... you are much appreciated lady!!!
Amazing work!!! If all professors could explain as clear as you do, we would live in a less stressed world, haha! Great Job!!!
Thanks Marco! 😃
Rightly said Marco...m a big fan of this teacher
@@LeilaGharani Hey
The Way you teach us is amazing
Can you tell how time you take to be such a expert in this
so glad that I've found this. I doing a workbook on Body Mass Index of a population (1,800+ people) with multiple factors aside from Age, Height, and Weight, such as Age Groups, Waist and wrist circumference, and Body Frame values.
Great video. Would you also be able to throw some light on how do you insert different scenarios like
>100025000
Assume that you have the value in cell B17 and you insert this function in C17 cell
=IF(B171000,B17=25000,B1739000,30%))))
This function will do what you have requested
Thanx Leila you are a great teacher I'll recommend you to my friends and families who are struggling with excel formula u make it very simple,keep up...
A Big fun of you from African horn, ETHIOPIA. May God pay you for your effort.
This lady is phenomenal, fantastic at explaining everything in detail. I am super happy and excited about taking all these courses. Thank you so much Leila, you are fantastic !!
Thank you so much!
Thank you leila
Queen of excell
I was searching excel channel i found your channel. my experience is top of the world
your explanation is really good, thank you!
I love how you’re conveying your information in a mathematical way , which helps in grasping not just memorizing, i rarely comment in youtube but i have to this time !
Leila, your videos are so clear and present amazing Excel capabilities that I haven't met in my 20 years with Excel. I've not yet finished this video, but I'm wondering why you didn't give C2 a name instead of referencing it as $C$2. I like names because they make formulas easier to read when I come back later and wonder what I was doing - such as "If (YTDRevenue > etc. Probably you discuss names in other videos that I haven't yet watched.
Thanks Leila, you're the BEST trainer/lector which I ever met.
Thank you for the kind words 🙏
Your work is nice
Glad you like it Imran.
I watch your videos your teaching style is very easy to understand and very simple
Great pics,
You explaining method is too good, I have through lots of channel but your way of explaining is too simple and impactful.
From today u are my Excel GURU
As usual, thank you for the video you make our work much easier!! Thank you
I'm very happy to hear that Hossam. Thank you for your nice comment.
Your really helping people improve their skills and the livelihoods for free. That is really noble and kind of you.
I'm happy if the tutorials are helpful.
I loved it. I've done using windings font. 😂😂😂
Thank you so much for making this confusing function comprehensible! The manner in which you speak is also very pleasant to the ear whilst learning!
Glad it was helpful!
Nice explanation. I was completely befuddled until I watched your video. Now I am not. Thank you.
Rick
The ONLY Excel video you'll EVER need!
Thanks!
Thank you!
The best IF video i have seen til now, what i like hte most is the file so i can practice myself. Thanks very much
Great explanation. I'd been looking for a good example of the OR function for days. This is the first I've found that really explains it.
Great videos. For the third example ( 7:12 ), an alternate slightly simpler method that doesn't require the AND is this:
=IF(B9>=$E$3,”Exceptional”,IF(B9>$E$2,”Good”,B9))
instead of:
=IF(AND(B9>$E$2,B9=$E$3,”Exceptional”,B9))
This also works well when there are many ranges (e.g., stratifications with many buckets) since you can just continue to daisy chain the IF statements.
Awesome job finding the most efficient formula. Where did you learn your skills from?
Searched through dozens of videos and finally yours answered my question, thank you!
Glad I could help, Charles!
Toujours d'une grande clarté, Leila !
You are WONDERFUL!!!!! Everything in your videos are perfect. Your voice, words you choose, speed, explanations, visuals, demeanor, just everything! Thank you so much for all of your hard work, I really appreciate you!
Wow, thank you!
This is my first video looking up how to use the if/or function, your examples are great and the explanations are very clear. Thanks for delivering such a clear instructions, you got another subscriber.
Glad the video is helpful Jon. Great to have you here!
They should allow multiple likes. Thanks for the tutorial again.
Thank you for your clear explanation. This is what is required when you are teaching excel, someone ...learning becomes sooo easy
Leila’s Excel videos are the best. Thank you.
Your personality and way of teaching is very impressive
Your efforts deserves much appreciation
So nice of you
Thank you so much Leila for this video. I have been working on something that was disturbing me as it involved a nine scale Risk Rating. With this video I have been able to pull it off. Thank you so much.
so well explain, you blow your peers away in the way you explain and demonstrate. thank you
Nice explanation. Instead of using OR for the logical test of the +- 10% Threshold (10:40) you can work with absolute numbers: =IF(ABS(B23/C23-1)>10%...
Thankyou so much for explaining this, really helpful (ive never had this explained to me). I nearly got it to work but like you mention at 7:40 in the video, excel understands the first part of the formula as the condition is true. However when the condition is not true it is NOT evaluating the second part of the formula (never mind).
if anyone sees this and can understand what im trying to do and they can see my mistake, I would be grateful for the answer
=IF(AND(B41=$A$40,"B41-$A$40/100*9"))
Basically if cell B41 is less than A40 then enter £0.00 but if cell B41 is > or = A40 then take B41 and minus A40 and then times by 9%
You are an amazing teacher ma'am ! thank you for helping a hobbist like me to learn excel and stay consistent in my learning journey
Just wanted to drop a comment that I automatically understood and applied the formula after watching this video so thank you so sooo much!
That's great to hear!
The best Excel channel in the all youtube and web!! Thank you!!!!!!!!
Wow, thank you Pablo!
Wow - you are the best in explaining - you really broke it down in chunks and brought at all together.
Hi Leila, fantastic, clear explanation of the IF function. Will be watching more of your Excel tutorials. Thank you!
My pleasure Robyn. Glad the tutorial is helpful.
It's amazing to learn excel from this channel. I am totally addicted to watching Leila teach useful Excel skills for my future career!
Thank you Leila , really Excel is being easy with your video. I’ll start share your channel with all my people.
That's great. Thanks for your support Mustafa!
I've watched several tutorials on Excel by other instructors. In my opinion, you are by far the best! Thank you for sharing your knowledge in such a clear and understandable way.
Thank you for the kind words.
Thanks alot, following you from 2 years ago and you have never failed me.
Thank you Leila, you are the great excel teacher. Your explanation is so clear and detail.
My pleasure. Glad to help.
Great work Leila Gharani. Now after going through this I understood how to use if with and formula.
Glad it was helpful!
Thank you…looks like you have it covered. You are super clear and have the nicest tone and pace which is easy to follow.
Thank you kindly!
My teacher sent this since we are in quarantine and it is the best thing he did because this is perhaps one of the greatest if not the greatest excel tutorial a human created. You got a sub and a like👏👏👏👏👏👏👏😁😁😉😉😊😊
Your voice is so calm and relaxing
Hi Leila you provided free education which help to learn detail. Thanks for the information and time you spend to create the free education video. i really appreciate your knowledge sharing :)
Leila you explain difficult things so simply that is great.
Just found your video this morning and I think it has saved my life - or at least my sanity! Thank you so much! I look forward to watching your others and learning how to not wreck my entire day with frustration! :-D
Glad it was helpful, Victoria :)
Good afternoon. I am working on my L2 Excel at college and the nested functions are a sticking point. I understand the process but not the nuances. This is a real help. Thank you.
Glad it's helpful Julian.
Thank you very much, Leila! I'm using the compound logic function for phone numbers in my P.O. spreadsheet. Depending on the supplier entered, their phone number appears in the corresponding cell! It's a game changer!
My every solution for Excel problem is @Leila Gharani Videos. Thanks a lot.
Practical explanations in an easy-to-understand language!!!!
you are doing a great service to all who need to learn Excel,, so thank you so much
So much appreciated!! I stuck somewhere. Bcz of your video, made it clear. Looking forward to your more videos!!!Love from india♥️
Leila Gharani, i really enjoying ur lecture, in fact, it is great and awesome.
thanks for sharing, excellent explanation and easy to follow 😃💯👍
I learned something new. Thanks! Love your videos about excel! From Philippines...
Great to hear, Juanito!
Calm, compose and comprehensive. You are dream of every XL student❤️
Thanks so much. can't thank you enough for showing me this in very simplistic way. it solved a big problem for me.
Enjoyed the cleared and simple step by step instructions
On my first click on youtube. I see you and I get the solution. You are the only one.
Glad to help :)
I challenge no one can do a better video than this. It is awesome thanks for sharing this video
Thank you very much for the kind words Ahmad! I'm really happy the tutorial is helpful.
Leila, your videos are clearly explain the content. Thank you!
I will buy your online Excel course, your method of teaching is just excellent.
That's great Leopold. Hope you'll like the course.
thank you so much i was looking at other videos for like an hour and finally i watched this one and i got it.