Using the Excel IF function | Excel Practice Case #19

Using the Excel IF function | Excel Practice Case #19 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

In this practice case we explore the use of the IF function in a live example.

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🙋🏼‍♂️ PLEASE SUBSCRIBE ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ 🆓 DOWNLOAD the Exercise file and solution for this video here 👉

SUPPORT THE CHANNEL ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n

Social Media / Contact us ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU 📥 Business Inquiries 👉 dexcelo03@gmail.com

📊 In this course you will learn how to: ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

• Join text using CONCATENATE
• Join text using JOINTEXT function
• Join text using the "&"
• Use the IF function to extract the order number
• Make the extraction interactive according to country selection

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✏️ Course developed by Dexcelo. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00:00 - 0:02:40 Intro & Objectives 0:02:40 - 0:08:23 Joining Text 0:08:23 - 0:12:12 Using IF function and simulation 0:12:12 - 0:13:40 Objectives Summary

🔗 Useful Links ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Thank you for your support 🙏🙏🙏 !!! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Tags #excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial ... https://www.youtube.com/watch?v=NvFIXMfpJv0