Premium Only Content

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
-
2:27:12
Nerdrotic
6 hours ago $16.90 earnedCIA JFK Assassination Documents | Forbidden Frontier 097
62.4K17 -
LIVE
Alex Zedra
3 hours agoLIVE! Verdansk all night <3
290 watching -
1:22:13
Sarah Westall
6 hours agoTruth about Gila Monster Snake Venom & the Miracle of Peptides for Human Health w/ Dr. Diane Kazer
59.2K11 -
2:18:43
Tundra Tactical
4 hours ago $2.65 earned$3200 ZEV HEARTBREAKER Contest!!!
28.7K1 -
LIVE
EuphioniaStudio
3 hours ago $0.04 earnedIt's BAAAASED, MARIO! | Mario Party 4
257 watching -
LIVE
ADH Gaming
5 hours agoWarzone Kar98 Iron sight Quick scopes
51 watching -
2:48:34
Adam Does Movies
13 hours ago $2.89 earnedAll The Big Movie Announcements From CinemaCon 2025- LIVE!
38K -
1:07:30
Josh Pate's College Football Show
6 hours ago $3.53 earnedBig CFB Changes Coming | USC + Texas + Alabama In 2025 | Truth About Officiating | I Am Engaged
39.5K1 -
4:43:40
Biscotti-B23
9 hours ago $1.79 earned🔴 LIVE VIEWERS VS MEMBERS BEEF 🔥 FINDING A NEW MAIN ⚔ BLEACH REBIRTH OF SOULS
28.3K2 -
3:21:55
DTDUBtv
6 hours agoOUTLAST TRIALS WITH SARAHSLOTH17
26.8K