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
-
6:05:51
SpartakusLIVE
6 hours ago#1 Texas FARMBOY Turned World-Wide Gaming SUPERSTAR amasses NERDS in chat from the ENDS OF THE EARTH
55K -
9:37
MattMorseTV
10 hours ago $1.39 earnedThis just ENDED his CAREER.
6.2K37 -
9:10:30
Spartan
9 hours agoPro Halo Player | Grinding, Another day to try and get better
27.4K1 -
2:31:12
Nerdrotic
7 hours ago $5.73 earnedCosmic Summit Recap, Skinwalker Ranch Season 6 | Forbidden Frontier #106
113K5 -
LIVE
This is the Ray Gaming
2 hours ago $0.63 earnedSunday Night With The Homies
285 watching -
2:26:29
vivafrei
16 hours agoEp. 270: MASSIVE SCOTUS WINS! Big Beautiful Bill! New-Scum Sues! Diddy Watch! Big Apple Rot & MORE
129K100 -
8:38:54
a12cat34dog
10 hours agoTHE *NEW* KRATOS IS EPIC :: God of War (2018) :: FIRST-TIME PLAYING {18+}
24K2 -
3:12:50
EricJohnPizzaArtist
4 days agoAwesome Sauce PIZZA ART LIVE Ep. #52: GEYCK!
28.7K3 -
57:30
RiftTV/Slightly Offensive
6 hours agoTHIS is Where It ALL Went Wrong.. The Rise of NEOCONS | Rift Book Club | B1E2
43.5K23 -
5:13:57
Barry Cunningham
10 hours agoBREAKING NEWS: SENATE FINAL DEBATE AND DISCUSSION ON BIG BEAUTIFUL BILL
161K95