Hi, can you get Excel to loop, i.e. add 1 to a value say B2, compare it to another cell B3, if < go to the add 1 loop and compare again. If it is > or = to stop looping.
i just wanna thank you .. 2 years ago i didnt have any knowledge about excel.... and not be confident at all... i love your vedios ... after one year im revising everything and i have forgot many of the notes for sure:> but you are great i really enjoy your tuturials
Leila -- Thank you for clueing me in to the use of F9 to check results within formulas. While the use of F9 function is not the purpose of your video, it is the gift I took away with me. And of course, a refresher on IFS is much appreciated too. Your tutorials are always helpful and enriching in direct and unexpected ways. As a student, I don't always know where to start asking questions but a gifted teacher helps me form my own questions. You are awesome!
Hi Leila.. thanks for the fun IFS and emoji formulas. In case anyone is interested, when using IFS, you can also terminate the final test with any non-zero numeral such as 1, as in: =IFS(B6>$C$3,"Higher",B6
This channel is my “go to” place whenever I think ‘there must be a better way to do this since I learnt excel 32 years ago’ 😀 Also enjoy how you learn or refresh yourself on another function - in this case conditional formatting. Relevant to the solutions well.. Thank you
What a way to start my morning! Though that might sound geeky, but there’s nothing better than starting the day learning something new and short. Thanks! I’m a huge fan.
Leila, well done on showing that IF/IFS could often be better performed by a VLOOKUP. So many people use a complex IF/IFS when a simple VLOOKUP is the best solution. Even Microsoft's video on IFS would be far, far better as a VLOOKUP.
I am new subscriber of your channel. I have been watching all of your videos since March and find all the videos full of new resources.thank you so much Leila Ma'am. I am grateful to be a part of your channel.
I've been using the IFS function for a while now, but when I first found it, it was such a revelation for me; a real game-changer. This is great content that is going to help out a lot of people. I have recommended your videos to so many people as you always have great content that is easy to explain.
Is it weird that I enjoy hearing your voice/ accent and they keep me engaged to watching and learning from your videos. I came to learn VBA recently from your channel, and ended up subscribing to learn more because you trully are a good teacher and your content is very nicely presented and thorough whilst making the complex bits really easy to understand..
What a fantastic tutorial. Thank you very much, this video has been the last after advice searching, and thanks to you I understand it much better. The speed, the clarity, the overall quality of your content is outstanding.
LOVE IT ! I was shy to use IFS because I didn’t know how to deal with the falses and didn’t bother to research it. I ‘m always looking forward to your Thursday videos. Thank you Leila !
Hi Leila, so cute... thank you I am somehow addicted to your videos and I think the time I spent with your courses is more than what I spent with my family.
This is great. You have a very clear and easy to understand approach, and the video quality is exceptional. I once had a spread sheet that had 9 IF’s in each cell, it drove me nuts. And I was the one who created it.
This is really good. Working in an bigger organization however takes away so much of the fun from new functions in Excel, as it sometimes can take REAL TIME until colleagues / other users have them available..
Hello Leila, I'm from Egypt I'd like to thank you for your fruitful ideas. I learnt more from your courses. I've already joined the course in the title "Excel Essentials for the Real World", it won't be the last one. I've never gained experience such this.
I am always surprised how easy and convenient you explain it. You always give me a lot of job satisfaction when I can use one of your useful tips again.
@Mikkysing26 aTHEist Thanks a lot! Indeed, not available for 2016. As we all figured out so far, Microsoft will stop updating any other version of office except 365. Everybody is hunting for subscriptions in favor of lifetime paid licenses. Reason is obvious. Sooner or later , almost everybody who wants Office ,will comply. The truth is, strictly from my POW, the benefits of only dynamic arrays and LET function are IMENSE. I can not understand how I was able to "excel" before that. If time is money, the amount of time you can save, pays the bill, twice. (average and heavy users). Peace ! Let's ask Leila her opinion too. 😉🙏
The most amazing 😍 part to me is that I never know boolean can be used in formula as it in VBA! It brings so much idea to me that how my projects can be improved, Thank you Leila!
@@codingsafari I've been on both sides of that. I like stored procedures and functions but our programmers are doing more in code now days. That's probably a result of the new technology in programming though.
Hi Leila!Great Tutorial,I Find The IFS Function So Much Easier To Write Compared To The Nested IF Formula.Love The Bonus Tip With VLOOKUP And XLOOKUP..Thank You :)
Once again, a well delivered lecture/lesson. 👍. I always look forward to your videos every week with the assurance that you won't disappoint by increasing my knowledge of Excel. Thanks and keep it up.
I have to agree with all of the sentiments already written. IFS is going to be a great tool in the future. SO much simpler than nested IF functions. I foresee this formula easily being included in my regular arsenal of tools!
You are a master. We as subscribers thoroughly enjoy your videos. In addition to excel, do you have expertise in SharePoint, if yes, please share videos
I am grateful for your amazing series of videos! I've been using Excel for well over 20 years and am always happy to add new Excel tools to my kit. Your videos are clear, concise, and very easy to follow - you have helped me up my Excel game in so many ways. My only frustration as a Mac user is that Microsoft has "downgraded" the functionality of their Mac versions of Excel. Can you produce some videos that help Mac users compensate for these shortfalls?
I to am using MacBook and find that quite a few functions are not available. Would request you to please upload videos on various functions of excel for Mac. Thanks
As usual, learnt so many new things! Keep up the great work Leila, you have a lifetime fan here! 😊(This emoji is not driven by IFS! it will be constant!)
I thank you very much, you really changed my life, I hope you would one day talk about the xml files and how to deal with them by excel. Thank you very much, you really do a great job
Thanks, Leila for another great tutorial as always Onto the next one(BTY I would like very much to know why someone can dislikes (6) this great video )
@@LeilaGharani It was unfortunate that I got to know about your channel very late but I have viewed almost all your videos ever since. It has helped me develop a complete system in my factory that records the attendance of more than 250 employees, keeps their wages records, monitor my production and also analyze the cost incurred on each product and that too with near 100% accuracy. I utilized the entire lockdown period but achieved what I intended to do finally. All your videos were of great help. I even invested in subscribing to Office 365 (prior to that I was using Office 2019). Thanks a ton.
Grab the file I used in the video from here 👉 pages.xelplus.com/ifs-function-file
Hi, can you get Excel to loop, i.e. add 1 to a value say B2, compare it to another cell B3, if < go to the add 1 loop and compare again. If it is > or = to stop looping.
4:00 THANK YOU! I have tried watching several videos trying to understand what the last catch all TRUE means, and you explained it perfectly.
My target to see daily one video of yours and am lot of improvements in my routine excel usage
I hope they'll be helpful for you.
i just wanna thank you .. 2 years ago i didnt have any knowledge about excel.... and not be confident at all... i love your vedios ... after one year im revising everything and i have forgot many of the notes for sure:> but you are great i really enjoy your tuturials
You are most welcome!
Leila -- Thank you for clueing me in to the use of F9 to check results within formulas. While the use of F9 function is not the purpose of your video, it is the gift I took away with me. And of course, a refresher on IFS is much appreciated too. Your tutorials are always helpful and enriching in direct and unexpected ways. As a student, I don't always know where to start asking questions but a gifted teacher helps me form my own questions. You are awesome!
Hi Leila.. thanks for the fun IFS and emoji formulas. In case anyone is interested, when using IFS, you can also terminate the final test with any non-zero numeral such as 1, as in: =IFS(B6>$C$3,"Higher",B6
i have not tried yet but if one of the criteria cells have error, you will probably get "same" too.
i learnt excel through a book -but your videos have got me addicted - great service leila, God bless
Glad you like them!
This channel is my “go to” place whenever I think ‘there must be a better way to do this since I learnt excel 32 years ago’ 😀
Also enjoy how you learn or refresh yourself on another function - in this case conditional formatting. Relevant to the solutions well..
Thank you
What a way to start my morning! Though that might sound geeky, but there’s nothing better than starting the day learning something new and short. Thanks! I’m a huge fan.
Leila, well done on showing that IF/IFS could often be better performed by a VLOOKUP. So many people use a complex IF/IFS when a simple VLOOKUP is the best solution. Even Microsoft's video on IFS would be far, far better as a VLOOKUP.
I am new subscriber of your channel. I have been watching all of your videos since March and find all the videos full of new resources.thank you so much Leila Ma'am. I am grateful to be a part of your channel.
Not sure what I would do without this channel. The catch all True in the end solved my issues. TY
Happy to help :)
I learn pretty much all my excel skills from you brilliant 👍 I just need to upgrade to Microsoft 365 now 😃
Great to hear! Thank you.
I actually passed my interview because of Leila's offset video =p
Every time I watch your lessons I feel the value of time with you increases and each lesson thank you very much for your, truly appreciate
I've been using the IFS function for a while now, but when I first found it, it was such a revelation for me; a real game-changer. This is great content that is going to help out a lot of people. I have recommended your videos to so many people as you always have great content that is easy to explain.
The IFS() function will be very useful. Thank you for demonstrating its features and touching on a couple of other approaches.
You are welcome!
Is it weird that I enjoy hearing your voice/ accent and they keep me engaged to watching and learning from your videos. I came to learn VBA recently from your channel, and ended up subscribing to learn more because you trully are a good teacher and your content is very nicely presented and thorough whilst making the complex bits really easy to understand..
Wow, thank you!
What a fantastic tutorial. Thank you very much, this video has been the last after advice searching, and thanks to you I understand it much better. The speed, the clarity, the overall quality of your content is outstanding.
LOVE IT ! I was shy to use IFS because I didn’t know how to deal with the falses and didn’t bother to research it. I ‘m always looking forward to your Thursday videos. Thank you Leila !
Glad it was helpful!
Hi Leila, so cute... thank you
I am somehow addicted to your videos and I think the time I spent with your courses is more than what I spent with my family.
Don't want to take time away from your family but I'm glad you like the videos :)
Great Ifs example. I always learn a lot from your excel tutorials. You are really amazing with your explanations. No one else comes close.
This is great. You have a very clear and easy to understand approach, and the video quality is exceptional. I once had a spread sheet that had 9 IF’s in each cell, it drove me nuts. And I was the one who created it.
Haha. Well, at least now you have more options, Edward :)
This is really good. Working in an bigger organization however takes away so much of the fun from new functions in Excel, as it sometimes can take REAL TIME until colleagues / other users have them available..
Good instructions ! I learned already quite a bit from your courses. You are my default “go-to” whenever I need a special Excel function ! Thank you !
I always find your explanations easy to understand and guidance easy to follow. I appreciate your time on these.
Glad to hear that!
please can you direct me on how to see your past videos. many thanks in advance.
Great tips... by far the best Excel tips on UA-cam. Thank you
Wow, thanks!
You are my Excel Pillar. Many thanks for all your contribution. I hope i can one day contribute to the society too
Your method of teaching is so simple yet so effective. Thanks for sharing. :)
Glad you think so!
Hello Leila, I'm from Egypt I'd like to thank you for your fruitful ideas. I learnt more from your courses. I've already joined the course in the title "Excel Essentials for the Real World", it won't be the last one. I've never gained experience such this.
I am always surprised how easy and convenient you explain it. You always give me a lot of job satisfaction when I can use one of your useful tips again.
Thank you. It makes me happy when you use the tips at your work!
Or a single cell formula for the whole column
=LET(arr,B6:B13,c,C3,SWITCH(TRUE,arr>c,"Higher",arr
@Mikkysing26 aTHEist Thanks a lot! Indeed, not available for 2016. As we all figured out so far, Microsoft will stop updating any other version of office except 365. Everybody is hunting for subscriptions in favor of lifetime paid licenses. Reason is obvious. Sooner or later , almost everybody who wants Office ,will comply. The truth is, strictly from my POW, the benefits of only dynamic arrays and LET function are IMENSE. I can not understand how I was able to "excel" before that. If time is money, the amount of time you can save, pays the bill, twice. (average and heavy users). Peace ! Let's ask Leila her opinion too. 😉🙏
Brilliant as always! Your videos are a real service to humanity.
Wow, thank you!
You have been my lifesaver on Excel Homework. THANKS !!!!
Leila, you are an amazing teacher! Thank you for sharing your knowledge in a way that's understandable and relevant.
Thanks for the IFS tutorial. Your graphics are amazing BTW! Very professionally done!
Another couple of functions I can definitely see myself using in the future and some great tips too. Thanks again Leila! You're a star :)
I use excel for years and I learned something new and useful. Thanks👌
Great to hear!
Nice explanation as always. For users of international versions, IFS in the Dutch version is called "als.voorwaarden" (if.conditions)
Thanks Rene!
The most amazing 😍 part to me is that I never know boolean can be used in formula as it in VBA!
It brings so much idea to me that how my projects can be improved, Thank you Leila!
Glad it was helpful!
Another great lesson. The IFS function is similar to the CASE statement in SQL which I use all the time. Thanks.
@@codingsafari I've been on both sides of that. I like stored procedures and functions but our programmers are doing more in code now days. That's probably a result of the new technology in programming though.
very nice example of using IFS in Excel, love the emoji concept too 😍
Hi Leila!Great Tutorial,I Find The IFS Function So Much Easier To Write Compared To The Nested IF Formula.Love The Bonus Tip With VLOOKUP And XLOOKUP..Thank You :)
You are so welcome!
Thanks Once again Leila. May the good Lord richly bless you for your generous contribution.
Excellent explanation and outstanding demonstration. Hats off Leila!
I Always follow You.. You are great instructor 😍😍😍😍
Your videos are fantastic (as usual). That catchall phrase "True" is super useful.
Thanks! 😃
Once again, a well delivered lecture/lesson. 👍. I always look forward to your videos every week with the assurance that you won't disappoint by increasing my knowledge of Excel. Thanks and keep it up.
Many thanks!
Ms. Leila, EXCELENT VIDEO on IFS and the tip at the end as well. Thank you!! You are awesome!!!
Very clear explanation of an excellent feature
Thank you for your great and clear explanation, Leila! You make me love excel more and want to know and learn something new everyday!
Happy to hear that!
Thanks!
Thank you, Anna!
Superb functionality with matching explanation
You are just amazing💕😍. After implementing your ideas I got appreciation from my management. Thank you so much 😍
Wow, that's great! I'm happy my tutorials can make such an impact.
I have to agree with all of the sentiments already written. IFS is going to be a great tool in the future. SO much simpler than nested IF functions. I foresee this formula easily being included in my regular arsenal of tools!
It's a great tool to have in your arsenal :)
Thanks for the great and straight to the point explanation!
You are a master. We as subscribers thoroughly enjoy your videos. In addition to excel, do you have expertise in SharePoint, if yes, please share videos
Thank you for adding the tip of emojis and true. Its a game changer.
Glad it's helpful.
Hi Leila, its always pleasure watching your videos. I have one query, can we know which option out of the four shown is resource friendly.
This video has rocked my world!!!!!!!! WOW. Thank you for posting this.
My pleasure, Bobby :)
Thank you so much, Leila. Your videos as always are very informative and easy to understand. Keep making such awesome content.
Thank you! Will do!
Every video is precious and worths watching and rewatching, thank you Leila.
Always I learn new things from your videos...thank you so much🥰😇
Thanks Leila. Had no idea you could use emojis in this way. Awesome as always.👍
You’re welcome 😊
Excellent teacher. I'm a big fan student of yours mam. 🙂
Very very nice, Love to see this, Love the way you demonstrated, taught and presented
Thank you! Cheers!
You're my favorite excel tutor.
Wow, thanks!
IFNA was a very nice touch. Great as always, thanks.
Glad you liked it!
I am grateful for your amazing series of videos! I've been using Excel for well over 20 years and am always happy to add new Excel tools to my kit. Your videos are clear, concise, and very easy to follow - you have helped me up my Excel game in so many ways. My only frustration as a Mac user is that Microsoft has "downgraded" the functionality of their Mac versions of Excel. Can you produce some videos that help Mac users compensate for these shortfalls?
I to am using MacBook and find that quite a few functions are not available. Would request you to please upload videos on various functions of excel for Mac. Thanks
Great explanation as always. I liked the TRUE trick at the end of formula
Cool, thanks!
Hi Leila, thank you for these useful tips. 👍 Have started exercising it especially the emoji shortcut😃😃😃😃
As usual, learnt so many new things! Keep up the great work Leila, you have a lifetime fan here! 😊(This emoji is not driven by IFS! it will be constant!)
Thank you! 😃
Thanks. Picked up lots of other short tips too including handy shortcuts 😊👍
Thanks for the IFS fun, Leila : )
Thanks teammate :)
Very handy. I can’t believe I have not seen this one before. I am going to use this. Thanks Leila!
Glad it was helpful, Lonny!
I always learn something new from Leila. Thank you so much!
Ahhh, that's the emoji 😁😁 super cute !!!!! Great idea, imma share this with my students too. Thanks for such awesome tutorial Leila 🤟
You’re welcome, Anne 😊
Fantastic tutorial of some many great techniques and new ways of working with Excel, Thanks Leila!
Glad you like it Darren!
Ok, I'm all in. I love your videos. I'm still not sure how I can make nested ifs leaner using xlookup, but I'm going to look at that next.
I thank you very much, you really changed my life, I hope you would one day talk about the xml files and how to deal with them by excel. Thank you very much, you really do a great job
I have learned so much from you. Thank you so so much. OMG I was just thinking about the xlookup I love it.
You are so welcome!
Thanks, Leila for another great tutorial as always Onto the next one(BTY I would like very much to know why someone can dislikes (6) this great video )
Thank you Leila, I had no idea IFS even existed. It looks to be very useful.
Hope it will come in handy :)
I always find your videos informative👍
thanks! like this short excel courses! love it!
As usual, there is something new to learn always. Keep up the good work.
Thanks, will do my best!
@@LeilaGharani It was unfortunate that I got to know about your channel very late but I have viewed almost all your videos ever since. It has helped me develop a complete system in my factory that records the attendance of more than 250 employees, keeps their wages records, monitor my production and also analyze the cost incurred on each product and that too with near 100% accuracy. I utilized the entire lockdown period but achieved what I intended to do finally. All your videos were of great help. I even invested in subscribing to Office 365 (prior to that I was using Office 2019). Thanks a ton.
Do we owe Leila a lot for such educational videos ?
TRUE, TRUE, TRUE, TRUE
🙏 Thank you
Thanks Leila. I had no idea about the WinKey . combo. Great stuff...
Glad it was helpful!
YOU ARE A SAINT THANK YOU
thank you very much for this video. I find it very useful for my job.
Working hard to get my employer to update to the current version of office. This is awesome for home projects on the laptop. Go 365.
Thank you Leila, learned something new today. Time to update those nested if on my reports.
very usefull video as always, I really like the way you present and explain, Thank you !!! much appreciated :)
Amazing video, so cool to use emojis. An alternative could be also SWICH function. In cell C6 for example
=SWITCH(TRUE,B6>$C$3,"Higher",B6
Thank you - that just solved a problem I have been working on for a long time!
Excellent! :)
Thank you. I've done many nested IF's over the years and dabbled in IFS. I was wondering how you do the 'Else' at the end.
Thanks Leila. IFS function is great!!! : ) : )
It really is!
Amazing trick Leila, time to look back at some of my ugly if statements!
LG - You are the best when it comes to Excel. I would like to do a detailed course in Excel. Please provide your valuable advise
If you're interested here is the link to my courses: www.xelplus.com/courses/
Excellent, Thank You.. LOVE your videos
Thank U, I will start watching your Excel videos on this channel.