You are really superb Chandoo. Coming from the Indian dub continent at 74 years, I started following your tips, and I have understood these formulas much more than before, and I can use them in many of my worksheets I do for a school. Thank you very much.
Chandoo, you saved my life! I had to use your second example (i.e., Any two out of three conditions) in a real world work assignment, and I got the solution I was looking for, :)
Hi Guru, Thanks for your IF and only IF TIPS....!!!! using the IF function for almost a decade from you... the Advanced TIPS to use excel extensively and wisely. keep Going ...!!!
So thankful to youtube and creators like you, who making this great knowledge available for free which we would not able to access if there was no youtube.
Hello Chandoo, your content is amazing. I love the way you take time and explain every part of the Function / Formula. Thanks a million. You are the best!!
Thank you very much Sir, I was struggling to use the IF function with wildcards on a major project I was stucked for a long time, this video was a life saver to over come that. Thanks loads and please keep doing this brilliant work. Wish you all the best. God bless you.
Hi Chandoo, thanks for the amazing tips. Many of these were unknown. Just found that the "on-call" thing can be done with the below formula too. =IF(OR(C8=$C$32:$C$36),"On Call","Not On Call"). Thanks
Thank you chandoo not only for this trick also for the excel file you made before to use as database I made some change and implemented in my company as an instant pallet generator still they are using the file everyday without showing any error.. 😊😊
Really enjoyed the graph example. I added an additional column for average to get a column with a static value and included it in my chart as a line type. It added a pop to the 2nd average overlayed bar showing a dynamic average line. Thanks!
in the wildcard assignment (column O) you dont need to do a countifs. Just write "=if(C8="*"&$O$5&"*","bo person","not a bo person". Great video, I definitely picked up a good handful of pointers
Hi Chandoo, loving your videos. For inventory analysis in manufacturing/warehousing, hope you can give us an excel method on how to determine the FEFO or "First Expiry/First Out" - *Fresher production dates are served instead of older ones* affected items. Considering the age requirements of multiple customers. This might be a bit complex, but hope you can give a simple and easy way.
your videos are straight to the point and it pleases me so much! I'm hooked from the first second =) I tried looking similar videos by other exel-pros, but yours are interesting, quick and with great examples. Thank you!
Excellent!!!!! Can you mentioned how many videos have to watch which is necessary for data analysis beginner as can not able to watch each and every video?? Please give reply Thanks for everything. Say yes to chandoo.....
Following you on website for years and today I found you here, immediately subscribed
Your examples are like patented inventions for free
Thanks Prashant for the love and support for all these years.
=IF("excellent learning needed"="yes" , "Chandoo" , "")
😊
😂
Excellent bro
Great stuff
Nice formula 😃😃
You are really superb Chandoo. Coming from the Indian dub continent at 74 years, I started following your tips, and I have understood these formulas much more than before, and I can use them in many of my worksheets I do for a school. Thank you very much.
I am using nested if function for lot of years. Now I came to know that there is a IFS function, much readable code.. You are awesome bro.
Great to hear!
I've struggled with the IF function for too long before I came across your channel. You're awesome. Thanks for the great stuff.
Chandoo, I have been following you since more than a decade now. Thanks once again for awesome tips and tricks!! These are so useful
Glad you like them!
you have a knack of making a difficult, look so simple and matter of fact- you are indeed one of the best on this subject
Thanks Michael.
Chandoo, you saved my life! I had to use your second example (i.e., Any two out of three conditions) in a real world work assignment, and I got the solution I was looking for, :)
I've been following you since nearly three years, and you are a wonderful Excel person, Chandoo!
Thank you so much!
Hi Guru, Thanks for your IF and only IF TIPS....!!!! using the IF function for almost a decade from you... the Advanced TIPS to use excel extensively and wisely. keep Going ...!!!
So thankful to youtube and creators like you, who making this great knowledge available for free which we would not able to access if there was no youtube.
How come is this free stuff on youtube? This is gem! Thanks for the awesome tips and tricks! Instantly subscribed.
Hello Chandoo, your content is amazing. I love the way you take time and explain every part of the Function / Formula. Thanks a million. You are the best!!
Thank you very much Sir, I was struggling to use the IF function with wildcards on a major project I was stucked for a long time, this video was a life saver to over come that. Thanks loads and please keep doing this brilliant work. Wish you all the best. God bless you.
I already learnt from you through your online course. You are Awesome.
Glad to hear that. Thank you so much for going thru the course :)
Hi Chandoo, thanks for the amazing tips. Many of these were unknown. Just found that the "on-call" thing can be done with the below formula too.
=IF(OR(C8=$C$32:$C$36),"On Call","Not On Call").
Thanks
Great tip!
Thank you chandoo not only for this trick also for the excel file you made before to use as database I made some change and implemented in my company as an instant pallet generator still they are using the file everyday without showing any error.. 😊😊
Excellent Demonstration. Great Efforts. Learnt a lot today. Thank You very much
There is IFS function?!! Man you just made my life so much easier 😄
You bet!
Really enjoyed the graph example. I added an additional column for average to get a column with a static value and included it in my chart as a line type. It added a pop to the 2nd average overlayed bar showing a dynamic average line. Thanks!
Good trick.
You're the best in explaining Excel! Love your channel and your videos, please keep us the good work. Love it.
Wonderful examples. I knew some functions existed but never thought to use them with IF
I am glad you found it useful. One powerful way I maximise my learning & memory is by thinking "I know A, I know B, I wonder if I can combine A&B"...
@@chandoo_ that’s a great strategy for learning
Once again thank you so much. You are very clear and easy to understand the instructions. You make the complicated far less so.
Aww.. thank you for that.
in the wildcard assignment (column O) you dont need to do a countifs. Just write "=if(C8="*"&$O$5&"*","bo person","not a bo person".
Great video, I definitely picked up a good handful of pointers
Thank you.
hmm.. which version of Excel you are using? When I test it on Excel 365, it doesn't work.
This guy is genius in excel. All the best Chandu.
Thank you Jitendra...
Thankyou for the video, the cell formatting is much easier than the way I was doing it .
Glad it helped
Thank you so much for teaching us for free.
Thank you sir for sharing such information in small videos with brief description and its functionality. It really helps
You are most welcome
I didn't know you could embed dates in your formulas! I use the between formula frequently and always have date inputs in cells. Cool stuff!
Awesome gyan. This is the best "If" class.
Thanks a ton.
Was revising Thank You again and God Bless You
Life changer Lessons... No words more needed... Thanks Chandoo
My pleasure
Chandoo Sir Thank you very much for your valuable training videos, Its really useful in my carrier ,
Sir your simplicity is exemplary
Wow! I thought I had advanced IF skills, but this adds some to my portfolio. Thanks!
Glad it was helpful!
who can ever dislike this video ? you rocks ! congratulation from Brazil
Aww.. thank you.
Hi Brazilian person, is gratis means free?
@@bintang13t yes . I am setting a moodle environment for that
@@chandoo_ welcome. This week I use it for find a zip code in a lista of ranges of zip codes
Hi Chandoo, loving your videos. For inventory analysis in manufacturing/warehousing, hope you can give us an excel method on how to determine the FEFO or "First Expiry/First Out" - *Fresher production dates are served instead of older ones* affected items. Considering the age requirements of multiple customers. This might be a bit complex, but hope you can give a simple and easy way.
Absolutely awesome! So glad I came about your page! :)
Sir I like your teaching style.
great examples Chandoo. love the level you're demonstrating; definitely matched the 'advanced' title. cheers
Thanks Rory. :)
Thank you so much for this Sir, I found the great examples I needed for my work. More power to your channel. God Bless.
Every learn something new from your videos
Thank you very much Mr. Chandoo.
♥
👍 Following you last many year...you are awasome
Thank you Amit 😀
your videos are straight to the point and it pleases me so much! I'm hooked from the first second =) I tried looking similar videos by other exel-pros, but yours are interesting, quick and with great examples. Thank you!
Thanks, Chandoo for ifs example here.. definitely i didn't understand boolean methos.. confusing
Hi Chandoo. Awesome IF function workout! Thanks for sharing :)) Thumbs up!!
=if (excellent learning needed" ="Yes", "Not to confuse with Boolean ", "Chandoo")
Hi Mr.Chandoo, Thanks for your effort. Best Wishes
A shorter solution to the "Review" challenge:
=IF(AND(YEAR(F8)=2019,MONTH(F8)
Thank you...chandoo sir
Your videoa are ao precise and to the point.. I am finding it very easy to learn and work
It's my pleasure
The boolaen replacement trick and a median used for dates trick are a good way to confuse the colleagues. Im definitly gonna use it :D Thanks Chandoo
I find that both of them also offer some speed improvements too.
@@chandoo_ i didnt think of this aspect. thanks for this detail.
Loved your tips and tricks. You're awesome. Thank you for spending the time to teach is us such awesome features. Keep going!
My pleasure!
What a trainer.... ❤❤❤
Love bro...
These were helpful, thank you Chandoo.
You are welcome Keisha.
very good lesson, thank you, Chandoo
You are welcome Omer...
very important, thank you!
Glad it was helpful!
Just loved it Chandoo!
You're amazing, thank you so much !
You are welcome Heather.
CHANDOO YOU ARE REALLY GENIUS
Thank you 😍
This is such a beautiful representation.
Thank you 😊
Thanks Sir for such a great video.
Excellent content!
Brilliant Chandoo - such very useful tips, thank you
My pleasure!
Thanks Chandoo!
Wonderful! Thank you for this!
Glad you enjoyed it!
thats what i need, thank you my brother 👌😁
I am glad you enjoyed it...
Thank you it was very helpful
You are welcome
one of the best channels!
Thank you :)
Great work! Like always i m impressed.Thank you for sheering this
Thank you florin...
Amazing Chandoo 👏
Excellent work brother, thanks.
My pleasure
Awesome video, very informative, thanks
Glad it was helpful!
Loved it totally
Logical function which are quite logical :)
Excellent!!!!! Can you mentioned how many videos have to watch which is necessary for data analysis beginner as can not able to watch each and every video??
Please give reply
Thanks for everything.
Say yes to chandoo.....
thanks sir really helpful i got confused when there are so many if constraints in the formula.
Great stuff, love the countif trick 👍
Thank you! Cheers!
Thanks buddy...I think I might use a couple of these going forward 😁
One word....Awesome...keep going mate
😀
Another great content Master Chandoo! Greetings from Philippines.
Hello there!
You are a magician.
Man, you are really good. Love your excel tips. Great job. I just subscribed.
Thanks for the sub!
I didn't expect the Pop quiz!! Saludos desde México
I hope you passed it ;)
I am in the presence of greatness...thanks Chandoo!
Wonderful!
Thanks Chandoo!
I'm from Philippines too.
Lots of new stuffs form me.
So cool!
I am grateful
Great video Chandoo. Many thanks!
My pleasure!
Superb... thank you so much :-)
😀😍
As always great video thank you
Very welcome :)
Thanks
Thanks for the love and super 😍
very valuable
Thank you so much chandoo sir ❤️
Always welcome
Another awesome video
Glad you enjoyed it
Amazing ❤
LEARBNED SOMETHING NEW THANKS
Now, since I have mastered IF formula, I no more use it. I either do it the boolean way or Xlookup or vlookup...
Thank you Chandoo for Another great video👌👌
Glad you enjoyed it
Chandoo you are awesome man..keep going...
Thanks ✌️