Chandoo, I have been following you since more than a decade now. Thanks once again for awesome tips and tricks!! These are so useful
@chandoo_3 жыл бұрын
Glad you like them!
@srinivasraogampala44203 жыл бұрын
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.
@chandoo_3 жыл бұрын
Great to hear!
@erickowaga5473 Жыл бұрын
I've struggled with the IF function for too long before I came across your channel. You're awesome. Thanks for the great stuff.
@MrRanjithm1 Жыл бұрын
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.
@mikelib623 жыл бұрын
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
@chandoo_3 жыл бұрын
Thanks Michael.
@akilj95028 ай бұрын
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!!
@taizoondean6894 ай бұрын
Was revising Thank You again and God Bless You
@sandipgumtya1303 жыл бұрын
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
@chandoo_3 жыл бұрын
Great tip!
@30ktothemoon762 жыл бұрын
How come is this free stuff on youtube? This is gem! Thanks for the awesome tips and tricks! Instantly subscribed.
@derrickpeoples18645 ай бұрын
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, :)
@m.raedallulu41662 жыл бұрын
I've been following you since nearly three years, and you are a wonderful Excel person, Chandoo! Thank you so much!
@Me-ow5rw3 жыл бұрын
I already learnt from you through your online course. You are Awesome.
@chandoo_3 жыл бұрын
Glad to hear that. Thank you so much for going thru the course :)
@iQuMaster3 жыл бұрын
There is IFS function?!! Man you just made my life so much easier 😄
@chandoo_3 жыл бұрын
You bet!
@shivsharma91533 жыл бұрын
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.
@dilansenn2 жыл бұрын
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.
@Skyggespil3 жыл бұрын
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
@chandoo_3 жыл бұрын
Thank you. hmm.. which version of Excel you are using? When I test it on Excel 365, it doesn't work.
@NodictatorsinKZ Жыл бұрын
You're the best in explaining Excel! Love your channel and your videos, please keep us the good work. Love it.
@KannadatiBindyaChannel2 жыл бұрын
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 ...!!!
@ishyamkumar33723 ай бұрын
Chandoo Sir Thank you very much for your valuable training videos, Its really useful in my carrier ,
@sukoi21133 жыл бұрын
Awesome gyan. This is the best "If" class.
@chandoo_3 жыл бұрын
Thanks a ton.
@BlockFHatter3 жыл бұрын
Once again thank you so much. You are very clear and easy to understand the instructions. You make the complicated far less so.
@chandoo_3 жыл бұрын
Aww.. thank you for that.
@patrickschardt77243 жыл бұрын
Wonderful examples. I knew some functions existed but never thought to use them with IF
@chandoo_3 жыл бұрын
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"...
@patrickschardt77243 жыл бұрын
@@chandoo_ that’s a great strategy for learning
@rory16533 жыл бұрын
great examples Chandoo. love the level you're demonstrating; definitely matched the 'advanced' title. cheers
@chandoo_3 жыл бұрын
Thanks Rory. :)
@timemerick7333 жыл бұрын
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!
@chandoo_3 жыл бұрын
Good trick.
@rosedesoloc80812 жыл бұрын
Thank you so much for teaching us for free.
@rajavintemakhan3 жыл бұрын
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.. 😊😊
@ayazmewati3194 Жыл бұрын
Sir your simplicity is exemplary
@michaelvincentmamongcara12082 жыл бұрын
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.
@ruthadere73143 жыл бұрын
very important, thank you!
@chandoo_3 жыл бұрын
Glad it was helpful!
@vitorpontes10483 жыл бұрын
Loved your tips and tricks. You're awesome. Thank you for spending the time to teach is us such awesome features. Keep going!
@chandoo_3 жыл бұрын
My pleasure!
@raghvendrasingh97213 жыл бұрын
Thank you sir for sharing such information in small videos with brief description and its functionality. It really helps
@chandoo_3 жыл бұрын
You are most welcome
@Oveeya Жыл бұрын
Absolutely awesome! So glad I came about your page! :)
@Patrick-ge2zn3 жыл бұрын
Thankyou for the video, the cell formatting is much easier than the way I was doing it .
@chandoo_3 жыл бұрын
Glad it helped
@aivie19002 жыл бұрын
Thank you so much for this Sir, I found the great examples I needed for my work. More power to your channel. God Bless.
@amihem10803 жыл бұрын
👍 Following you last many year...you are awasome
@chandoo_3 жыл бұрын
Thank you Amit 😀
@vaibhavmhaske1733 жыл бұрын
Thank you...chandoo sir Your videoa are ao precise and to the point.. I am finding it very easy to learn and work
@chandoo_3 жыл бұрын
It's my pleasure
@tapanbarick957211 ай бұрын
Sir I like your teaching style.
@wayneedmondson10653 жыл бұрын
Hi Chandoo. Awesome IF function workout! Thanks for sharing :)) Thumbs up!!
@christianreed43962 жыл бұрын
Wonderful! Thank you for this!
@chandoo_2 жыл бұрын
Glad you enjoyed it!
@prashantsteele2 жыл бұрын
Life changer Lessons... No words more needed... Thanks Chandoo
@chandoo_2 жыл бұрын
My pleasure
@HacTacbka Жыл бұрын
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!
@cursodeexcelcompletogratis77733 жыл бұрын
who can ever dislike this video ? you rocks ! congratulation from Brazil
@chandoo_3 жыл бұрын
Aww.. thank you.
@bintang13t3 жыл бұрын
Hi Brazilian person, is gratis means free?
@cursodeexcelcompletogratis77733 жыл бұрын
@@bintang13t yes . I am setting a moodle environment for that
@cursodeexcelcompletogratis77733 жыл бұрын
@@chandoo_ welcome. This week I use it for find a zip code in a lista of ranges of zip codes
@francisaranha Жыл бұрын
Just loved it Chandoo!
@peerzsalim17222 жыл бұрын
Hi Mr.Chandoo, Thanks for your effort. Best Wishes
@siddiqbinsalam12843 жыл бұрын
Excellent work brother, thanks.
@chandoo_3 жыл бұрын
My pleasure
@jet-joyexceltraining84182 жыл бұрын
Every learn something new from your videos
@keishrich3 жыл бұрын
These were helpful, thank you Chandoo.
@chandoo_3 жыл бұрын
You are welcome Keisha.
@nirmalabolar13822 жыл бұрын
Awesome video, very informative, thanks
@chandoo_2 жыл бұрын
Glad it was helpful!
@satishgundoji11443 жыл бұрын
one of the best channels!
@chandoo_3 жыл бұрын
Thank you :)
@jitendrapatel18313 жыл бұрын
This guy is genius in excel. All the best Chandu.
@chandoo_3 жыл бұрын
Thank you Jitendra...
@JustOkko3 жыл бұрын
Wow! I thought I had advanced IF skills, but this adds some to my portfolio. Thanks!
@chandoo_3 жыл бұрын
Glad it was helpful!
@heather74613 жыл бұрын
You're amazing, thank you so much !
@chandoo_3 жыл бұрын
You are welcome Heather.
@lesleywells34972 жыл бұрын
Excellent content!
@osirkeci3 жыл бұрын
very good lesson, thank you, Chandoo
@chandoo_3 жыл бұрын
You are welcome Omer...
@florincopaci68213 жыл бұрын
Great work! Like always i m impressed.Thank you for sheering this
@chandoo_3 жыл бұрын
Thank you florin...
@gavidiharish13 Жыл бұрын
What a trainer.... ❤❤❤
@blazerbeavs2333 Жыл бұрын
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!
@GeorgeAJululian3 жыл бұрын
Thank you it was very helpful
@chandoo_3 жыл бұрын
You are welcome
@andreluizsales32862 жыл бұрын
Thanks Chandoo!
@bobwhelan56443 жыл бұрын
Brilliant Chandoo - such very useful tips, thank you
@chandoo_3 жыл бұрын
My pleasure!
@AdityaKumar-br1dx Жыл бұрын
thanks sir really helpful i got confused when there are so many if constraints in the formula.
@ragavendra77 Жыл бұрын
Amazing Chandoo 👏
@ozgur9373 жыл бұрын
This is such a beautiful representation.
@chandoo_3 жыл бұрын
Thank you 😊
@flickafy3 жыл бұрын
Great tips Chandoo, thank you. Glad you've launched a KZbin channel too in addition to your excellent website - the comments section of those has always been a useful read too. I learnt a lot from this video, not just from the bonus and Boolean tips, but some nice chart ones too, thanks! Was wondering about the XOR "exclusive or", given it has excluded where an individual meets both criteria. Is there an alternative formula you'd recommend so that someone who meets both doesn't get excluded since they qualify for both? Thanks!
@chandoo_3 жыл бұрын
Thanks. Yes, I always feel like comments on the site & now here on YT is a gold mine for learning new things. You can use the good old OR function in your case btw.
@FRANKWHITE19963 жыл бұрын
As always great video thank you
@chandoo_3 жыл бұрын
Very welcome :)
@briandennehy63803 жыл бұрын
Great stuff, love the countif trick 👍
@chandoo_3 жыл бұрын
Thank you! Cheers!
@defrinaelsianipar98833 жыл бұрын
thats what i need, thank you my brother 👌😁
@chandoo_3 жыл бұрын
I am glad you enjoyed it...
@acommonman155 Жыл бұрын
Loved it totally
@silasalexbob3 жыл бұрын
Hi Chandoo! Awesome video! The boolean was so cool. I have a doubt @12:35 - I used "=IF(COUNTIF($C$32:$C$36,C8),"On call","Not on call")" instead of your Countifs formula and it works the same for me. Any reason you are preferring the Countifs?
@chandoo_3 жыл бұрын
Both COUNTIF and COUNTIFS work in this situation. I always use xIFS version because they give me an option to add conditions in future. One less thing to remember too.
@nandakishorecb29583 жыл бұрын
Superb... thank you so much :-)
@chandoo_3 жыл бұрын
😀😍
@algr6653 жыл бұрын
Man, you are really good. Love your excel tips. Great job. I just subscribed.
@chandoo_3 жыл бұрын
Thanks for the sub!
@falaksharma12 жыл бұрын
Thanks Sir for such a great video.
@mickaell34512 жыл бұрын
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
@chandoo_2 жыл бұрын
I find that both of them also offer some speed improvements too.
@mickaell34512 жыл бұрын
@@chandoo_ i didnt think of this aspect. thanks for this detail.
@tlc17953 жыл бұрын
Thank you !
@arnabsaha332 жыл бұрын
Interested in your excel school course. Do I get live class or only recorded video? Do I get to download the videos?
@raitup003 жыл бұрын
I didn't expect the Pop quiz!! Saludos desde México
@chandoo_3 жыл бұрын
I hope you passed it ;)
@johndurran6143 жыл бұрын
Another awesome video
@chandoo_3 жыл бұрын
Glad you enjoyed it
@krishnakishortiwari87243 жыл бұрын
how I can use the lookup function where you used countifs function?
@chandoo_3 жыл бұрын
Use it like this =IF(XMATCH(your_value, on_call_list, 0),"On call", "Not on call")
@TechWrite3 жыл бұрын
Great video Chandoo. Many thanks!
@chandoo_3 жыл бұрын
My pleasure!
@canirmalchoudhary81733 жыл бұрын
CHANDOO YOU ARE REALLY GENIUS
@chandoo_3 жыл бұрын
Thank you 😍
@meniporat35273 жыл бұрын
A shorter solution to the "Review" challenge: =IF(AND(YEAR(F8)=2019,MONTH(F8)
@giandenorte3 жыл бұрын
Another great content Master Chandoo! Greetings from Philippines.
@chandoo_3 жыл бұрын
Hello there!
@qasmb15462 жыл бұрын
Hi, Excellent video! Can I ask why you put an extra opening bracket for the Any two out of three conditions formula? what does that do exactly? Thank you.
@chandoo_2 жыл бұрын
Hmm.. may be you are not using Excel 365..?
@qasmb15462 жыл бұрын
@@chandoo_ I am using excel 2016.....Does that formula only work in excel365?
@ardip.69303 жыл бұрын
Thanks buddy...I think I might use a couple of these going forward 😁
@aseemgoyal1013 жыл бұрын
One word....Awesome...keep going mate
@chandoo_3 жыл бұрын
😀
@dharagajera29023 жыл бұрын
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.....
@Minhasacademy2 жыл бұрын
Thank you so much chandoo sir ❤️
@chandoo_2 жыл бұрын
Always welcome
@ravi__negi__4333Ай бұрын
LEARBNED SOMETHING NEW THANKS
@silverfunnel68193 жыл бұрын
Very helpful, thank you!
@chandoo_3 жыл бұрын
Thank you Silver...
@uwadiegwuemmanuel88092 жыл бұрын
I am grateful
@Zaimulwaie Жыл бұрын
i'm confused regarding the boolean replacement part. if the department is sales and 2018, wouldnt 2% - 1(because its true)*1% make it 1%. what does the '-' sign in front of 2% mean? is it a subtraction or does it perform a different function, because i notice there are spaces before and after the '-' sign
@kashmoney13 жыл бұрын
Thanks 👍 amazing video...quick ❓...I usually build dashboards suming up 3-4 criteria at once (via dropdowns); which formula do you recommend to use? I use sum formula which is quick and also do xlookups but didn't know if you have any tricks on that or any videos...!thanks as always bro!
@chandoo_3 жыл бұрын
I use SUMIFS or other xIFS formulas for such things. If there is a bit more to the logic, then naturally lookups & INDEX will follow. Consider using new dynamic array functions to simplify the process or sorting the outputs too.
@kashmoney13 жыл бұрын
@@chandoo_ thanks 👍🫂
@michafabich92132 жыл бұрын
very valuable
@pavancena98Ай бұрын
I have a large dataset with more than 5lac line items.. how can I work in excel? Does power query or power pivot or anyother tool helps?
@shaitarun Жыл бұрын
Amazing ❤
@RobertAfrick3 жыл бұрын
I am in the presence of greatness...thanks Chandoo!
@chandoo_3 жыл бұрын
Wonderful!
@arnabsaha332 жыл бұрын
You are a magician.
@pektuspektus6123 жыл бұрын
Thanks Chandoo! I'm from Philippines too. Lots of new stuffs form me.