How to Use IF Statement & Drop Down Menu in Excel
HTML-код
- Опубликовано: 28 май 2024
- In this tutorial, we will show you how to create a drop down based on an IF statement in Excel. First, we will show you how to create a drop down list that will allow you to first select the criteria for the second drop box. Then, we will show you how to make a second drop box to take the value of the first one and return different values in the list based on what has been selected in the first box. This is a great video for anyone wanting to use an IF statement to determine which values should be in a drop down box in Microsoft Excel.
Check out our Blog entry for IF Statement & Drop Down Menu in Excel here:
www.myexcelonline.com/blog/if...
IF Statement & Drop Down Menu in Excel Time Stamps⌚
00:00 - Introduction to IF Statement & Drop Down Menu in Excel
00:49 - Creating the Criteria Drop Down in Excel
01:32 - Creating the Drop Down with an IF Statement
02:56 - Testing the Drop Downs in Excel
03:18 - Conclusion for How to Use IF Statement & Drop Down Menu in Excel
------------
🔥 OUR BEST EXCEL RESOURCES 🔥
👨🏫 Get 30+ Excel & Office Courses & support for 60% OFF! 💵 (All Excel levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!
Join Now & get 60% OFF (limited time offer) 👉 www.myexcelonline.com/107-42....
📚 Download Our Free 101 Excel Tips & Tricks E-Book:
Download for FREE 👉www.myexcelonline.com/101-exc...
💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:
Access for FREE 👉www.myexcelonline.com/107-3.html
📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:
www.myexcelonline.com/107-59....
📚101 Most Popular Excel Formulas Paperback on Amazon:
www.amazon.com/dp/1700300911
📚101 Ways To Master Excel Pivot Tables Paperback on Amazon:
www.amazon.com/Ways-Master-Ex...
📚101 Ready To Use Excel Macros Paperback on Amazon:
www.amazon.com/dp/1700729675
📚101 Best Excel Tips & Tricks Paperback on Amazon:
www.amazon.com/101-Best-Excel...
👷 Excel Consulting Services:
www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
/ @myexcelonline
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MyExcelOnline #dropdown #IF #MsExcel
Your work is truly impressive! Could you share your thoughts on my work?🙂🙏
Thanks! So glad you like it! Yes, we can review work! Check out this link: www.myexcelonline.com/microsoft-excel-consulting-services/