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
-
LIVE
Inverted World Live
1 hour agoFake Police Try to Steal Buga Sphere | Ep. 65
3,613 watching -
2:44:50
TimcastIRL
3 hours agoTrump ROASTS "Communist Lunatic" Zohran Mamdani after NYC Dem Primary Win | Timcast IRL
203K48 -
LIVE
Laura Loomer
1 hour agoEP129: NY Democrats Elect Jihadi Communist
1,337 watching -
3:01:30
Barry Cunningham
3 hours agoPRESIDENT TRUMP HAS SPARKED A NEW ATTITUDE! DO YOU FEEL IT?
43.1K17 -
LIVE
RalliedLIVE
7 hours ago $1.21 earnedSpecialist Addicted Man Plays Warzone
374 watching -
LIVE
I_Came_With_Fire_Podcast
4 hours agoFaith & America's Founders
225 watching -
9:21:33
Dr Disrespect
11 hours ago🔴LIVE - DR DISRESPECT - THE BEST IS BACK!
158K23 -
DVR
Badlands Media
19 hours agoAltered State S3 Ep. 34
37.2K3 -
43:41
CarlCrusher
1 hour agoSHOCKING Discovery on the Path of the Skinwalker | Thunder Strike Ranch | Episode 2
4.07K -
30:58
Solar Groove Muzic
22 hours ago $0.08 earnedSUMMER AFRO HOUSE BEATS of 2025
4.47K