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
-
1:08:36
Man in America
13 hours agoUS, China, Israel & the Battle for the New World Order w/ Boone Cutler
74.2K50 -
2:37:49
The Connect: With Johnny Mitchell
1 day ago $7.48 earnedBlackwater Mercenary EXPOSES Private Military War Secrets From The Middle East, Fueling Terrorism
35K33 -
2:54:21
Total Horse Channel
2 days ago2025 Scottsdale Arabian Horse Show | Saturday Evening Session
73.3K6 -
22:39
The Mel K Show
9 hours agoMel K & Representative Brandon Gill | Our Constitutional Republic is Being Restored | 4-26-25
55.6K46 -
4:17:17
VapinGamers
9 hours ago $4.95 earned📣 Fortnite Family Night! - Games and Dubs with BrianZGame - !rumbot
44.1K3 -
4:27:48
ThePope_Live
7 hours agoLIVE - First time playing The Finals in over a YEAR! Still good? with @Arrowthorn
34K1 -
3:06:26
TruthStream with Joe and Scott
13 hours agoRoundtable with Patriot Underground and News Treason Live 4/26 5pm pacific 8pm Eastern
56.1K34 -
8:52
Tundra Tactical
11 hours ago $10.02 earnedSCOTUS Denies Appeal, Minnesota Courts Deal 2a Win!
55.5K11 -
10:36:01
a12cat34dog
13 hours agoONE WITH THE DARK & SHADOWS :: The Elder Scrolls IV: Oblivion Remastered :: FIRST-TIME PLAYING {18+}
77K6 -
22:27
Exploring With Nug
20 hours ago $12.87 earnedSwamp Yields a Chilling Discovery in 40-Year Search for Missing Man!
67.9K17