Thank you very much! i needed to help my manager with an excel spreadsheet at work. im new there and my excel skills are a bit laggy since we moved away from the spreadsheet models in my IT course. obviously everyone looked at me for help and i said yes haha (im a newbie at my place of work and i want to seem helpful). but thanks again and best of luck!
😍 Thanx Bro... U Explained All If and, AND Functions within 5 minutes without lagging.... I've not studied Excel more, so i didn't knew to add Multiple Cells, and multiple functions... This solved all my doubt😊
Great video man. You made me realize where I was going wrong in my three line long formula and will make adjustments thanks to your explanation. Thanks !
So that's why my nested ifs would work. Really helpful video man! Thanks! *side note tho, the sound is kinda annoying with the keyboard tapping and all that, you might wanna bring it down a notch or two.
Tutorial was really good. But I have a question . Is there a way you can add two outputs together to have another output? Like medium + high . How would you write that ?
This is excellent. Thank you. Do you how I can use vba (without the autofilter) to delete rows that have a cell in column A with a blank OR a date (any date in it)? Thank you.
@@ExcelDestination ok thanks... Is there any example videos of that, so that I can refer that... Pls share me that link of we have. Thanks for your help
Could you show a formula that includes a column for a "role" category like if the person is either a clerk, an agent, or a lead. Each role would have a different range. So let's say for example the added Role column shows the person worked as a clerk, and we use these ranges as examples - their Low range would be Less than or equal to 1000, their medium range would be more than 1000 and less than or equal to 4000, their High range would be more than 4000 and less than 9000, and their Top Level would be more than 9000. and another person worked as a lead so their ranges would be Low range less than or equal to 3000, their medium range would be more than 3000 and less than or equal to 6000, their High range would be more than 6000 and less than 11000, and their Top Level would be more than 11000.
Hi. I have 5 criteria for ratings for employees and each criteria has 3 sub criteria. I need help to put a formula to automate the final rating of the person after meeting a particular set of criteria
If both the column range are not same then, How we can apply nested IF or nested IF(AND) which one to apply and how to apply with formula pls explain it sir?????
This dude literally just saved my grade so hard. I messed this up every week, but on the final exam I got this right, thanks to this guy!
You're a king bro
Journey Finished after 3 hours of Research, thank you so much.
Welcome
Finally your video has solved by problem. Thank you for your great job.
Glad to hear that
This is simply brilliant, explained in such a simple manner. I was able to implement this on a multiple choice questions scoring in xls in no time.
thanks
The perfect information in less than 5 minutes. Legend!
Finally I found this video to help me write multiple if statements. Thanks, it helped me solve my problem!
There is nice example to teach with multiple condition thanks a lot dear
It's my pleasure
Universal rule for all excel tutorials: the audio must always be too quiet for normal speaker volume.
that and someone with an accent too thick to understand
@@unclespicy3318 i can understand him just fine tbh no problems
Thanks for addressing what no one else would!
Excellent .............. I am grateful for such a simple and short solution
This video is well put together. I have viewed others and no results. THANK YOU VERY MUCH!!
Thank you very much! i needed to help my manager with an excel spreadsheet at work. im new there and my excel skills are a bit laggy since we moved away from the spreadsheet models in my IT course. obviously everyone looked at me for help and i said yes haha (im a newbie at my place of work and i want to seem helpful).
but thanks again and best of luck!
Taiyyab gmail com email 👨💻💼👨🎓👔👖👞🕶💴💴💴💶💶💶💵💵💵
Lego or not, thanks for helping me with a problem i was trying to solve on my own for 1 hour!
Thank you so much, this has made work a lot easier for me. Thx again.
You're welcome!
finally i found this video.. it helped me to solve my problem.... God Bless
Thanks Ren for your great comment!
Thank you so much! I've spent about 3 hours searching for the solution you showed in your video. Thank you!
Thank you, finally for the past 12 hourly.
😍
Thanx Bro...
U Explained All If and, AND Functions within 5 minutes without lagging....
I've not studied Excel more, so i didn't knew to add Multiple Cells, and multiple functions... This solved all my doubt😊
Simple and easy to understand. Thank You!
Welcome
Great video man. You made me realize where I was going wrong in my three line long formula and will make adjustments thanks to your explanation. Thanks !
Thanks for your comment! I am glad, I could help you!
No other searches mentioned the 'and' command - this is perfect-Thanks!
been stuck for a long time but this video SAVED MY ASS THANK YOU SO MUCH!!!
welcome
Which i was searching for. thanks man.
Welcome 👍
Thank youuuuuuu so much! I wish I could have seen this before our exam. This is exactly what I'm looking for
Thanks for Watching!
Thanks Bro This is exactly what I'm looking for
Glad I could help
So that's why my nested ifs would work. Really helpful video man! Thanks!
*side note tho, the sound is kinda annoying with the keyboard tapping and all that, you might wanna bring it down a notch or two.
Oh Wow! Thank you sooooo much for posting this. It's EXACTLY what I needed right now. You legend!
Thank you so much for this!!!!! Very good practice. 🍾
You're so welcome!
Waw Finally problem Solved , Thanks you are a Legend !
welcom
Thanks for sharing this tutorial with good example
Glad it was helpful!
This is so helpful. Thank you very much.
Glad it was helpful!
Thank you, this tutorial helps me a lot
it's a really nice video & it gives clear information to learners to understand the formula easily. thank you very much ..
Exactly what I was looking for! Thank you!
I DONT NEED GOOD AUDIO COZ I CAN SEE IT ..AND I GOT IT AND Y PROBLEM SOLVED..THANKU SO MUCH
Thanks for your nice comment!
for any excel OR vba question write to EXCELDESTINATION@GMAIL.COM...
This was very helpful, thank you so much!
Thanks brother for your tips, It is really helpful
thank you so much. very useful.
You are welcome!
Thank you for the tutorial 👍
Thank You. I figured it what was my mistake.
Big Thank you for You respected sir...............
Most welcome
thank you so much, it helped me a lot
Thanks
Thanks for sharing! This helped me so much!
Great Job!
Thanks!
You are a savior!!!
Thanks
Well explained bro....Thank you
The sounds in the background. Yeeesh. Good content tho 😀
Great one!
Thank you!
Glad you liked it!
Thanks a lot man!
Happy to help!
Very helpful for treatment of data
Thanks
Thank you brother :)
Welcome
Thank you, again!
Thanks again!
straight and simple. very useful, thank you
Thanks Mnna for your comment!
Thank you much for this
welcome
very useful ...keep it up....👍👍👍👍👍
Thanks a lot
Tutorial was really good. But I have a question . Is there a way you can add two outputs together to have another output? Like medium + high . How would you write that ?
Very much helpful. Thanks
is your keyboard made from legos?
I also thought of that.
:)
Lol. It sounds like he has a mechanical keyboard. I like them. It’s like the difference between weighted and non weighted keys on a piano keyboard.
what is legos
@@abbasshah6464 tf
Thanks Love your Work
thank you so much for this lesson
This is exactly what I needed! THANKS!
Thanks for your comment!
Thank you so much !
You're welcome!
This is excellent. Thank you. Do you how I can use vba (without the autofilter) to delete rows that have a cell in column A with a blank OR a date (any date in it)? Thank you.
you can take help from following tutorial :
th-cam.com/video/IoPvnbfo1i4/w-d-xo.html
Thank you so much dear, u made my day. ❤️😊
Thank you very much! it helped me do my assignment!
Thanks for your watching!!!
I forget this formula, thanks for remain again.
Perfect, thanks a lot for such helpful video.
thanks for watching!
Thank you very much 🙏
You're most welcome
Thank you sir 👍🏻👍🏻👍🏻👍🏻
Welcome
Thank you bro 🙂🙂🙂
Welcome 😊
Sorry newbie here, are "AND" really used on those case? I tried with
=if(C3
Super, Nicely explained ! Thanks
very helpful, thank you sir
Thank you, this is was sooooo helpful.
Thanks for watching!
Thank you dear❤️❤️❤️
You’re welcome 😊
Thank you so much for your kind help~
Thanks..Helpful
Great video and very helpful - thanks!
Thanks for watching!
Great Video! Thanks for positing.
if we don't use "and " in the nested if function do we get the same result ? or is it different
pls. try and share your experience.
Your video saved my life HAHAHHA. Thank you.
thanks for watching!
Thank you really enjoyed your formula
Thank you!
Welcome!
I want to choose multiple cells for just 1 condtiton.. How to do it??? I am a learner
Thank you so much
You're most welcome
Thanks so much for this video.
Can we also included the vlookup function ?
yes
@@ExcelDestination ok thanks... Is there any example videos of that, so that I can refer that... Pls share me that link of we have. Thanks for your help
a nice formula, not sure about the ands, if you record a nice quality video plus explain more about why you are doing your formula like that
Could you show a formula that includes a column for a "role" category like if the person is either a clerk, an agent, or a lead. Each role would have a different range. So let's say for example the added Role column shows the person worked as a clerk, and we use these ranges as examples - their Low range would be Less than or equal to 1000, their medium range would be more than 1000 and less than or equal to 4000, their High range would be more than 4000 and less than 9000, and their Top Level would be more than 9000. and another person worked as a lead so their ranges would be Low range less than or equal to 3000, their medium range would be more than 3000 and less than or equal to 6000, their High range would be more than 6000 and less than 11000, and their Top Level would be more than 11000.
send me your file and question with some dummy data. I will provide the formula
Thanks, I sent my sample rating sheet to you via email.
i will check and respond
Hi. I have 5 criteria for ratings for employees and each criteria has 3 sub criteria. I need help to put a formula to automate the final rating of the person after meeting a particular set of criteria
If you can send me email at exceldestination@gmail.com with some dummy data and conditions. I can provide you solution 100 %
If both the column range are not same then,
How we can apply nested IF or nested IF(AND) which one to apply and how to apply with formula pls explain it sir?????
Do I need to use spaces to separate them?
please try
Very helpful, thank you.
thank you!
welcome
Thanks Ryan!!!
Taiyyab gmail com email 👨💻👨🎓💼
VERY HELPFUL
For every confused student, there is an indian ready to teach him xD (btw i love indian im not hating)
Dang why u hating man
Thank you.
Thanks a lot!!
saved my day
Thanks for watching!