Premium Only Content

Properly Use Excel IFS Function
9 July 2020 Excel Intermediate Functions & Features (For ALL Excel Versions)
The IF function is one of the most popular functions in Excel. But writing nested Excel IF formulas in situations when more than 1 condition has to be checked can become cumbersome. If you have Excel 2019 or Microsoft 365 you can use the Excel IFS function instead.
In this tutorial I'll show you how easy it is to use this logical function when testing for multiple criteria. Your formulas will be much easier to read.
Since the IFS function only checks for the TRUE condition, how can you include an else condition in IFS? There is a simple way around this. Check it out at minute 02:42.
I'll also show you how you can use conditional formatting in Excel (on emojis) to visualize results better.
As a special bonus tip I'll cover how you could replace the Nested IF formulas with the VLOOKUP function.
⯆ Workbook is available here: https://www.xelplus.com/excel-ifs-function/ (scroll to the bottom of the post)
Link to Excel IF formula: https://youtu.be/KkTaQ5OjAGc
Link to VLOOKUP video: https://youtu.be/hwL6KKJP-_I
Link to XLOOKUP video: https://youtu.be/xnLvEhXWSas
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Time Stamps
00:00 Excel IFS instead of Nested IF formulas
00:37 Testing for 3 conditions with IFS
02:42 How to include "else" statement in IFS
04:40 Excel IFS with conditionally formatted emojis
09:06 Use Excel VLOOKUP instead of Nested IF
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
2:42:10
TimcastIRL
12 hours agoTrump To SHUTTER 120 IRS Offices In MASS PURGE, Democrat LEAKED Tax Info w/Mike Crispi | Timcast IRL
193K68 -
3:21:29
Alex Zedra
11 hours agoLIVE! New Game | R.E.P.O
51.6K4 -
1:52:42
Kim Iversen
13 hours ago💰 CHA-CHING! 💰 Trump Unveils Big Money Plans For Gaza AND America
67.5K201 -
1:05:28
Flyover Conservatives
1 day agoUkraine’s Dirty Secret: The Christian Persecution No One Wants to Talk About - Alex Newman | FOC Show
68.2K25 -
2:00:20
Glenn Greenwald
18 hours agoThe View from Moscow: Key Russian Analyst Aleksandr Dugin on Trump, Ukraine, Russia, and Globalism | SYSTEM UPDATE #414
167K68 -
1:10:55
Donald Trump Jr.
15 hours agoBREAKING NEWS: My Father Revokes Biden-Maduro Oil License, LIVE with Maria Corina Machado | Triggered Ep.220
227K211 -
1:25:29
Sarah Westall
13 hours agoX-Files True History, Project Blue Beam, Cabal Faction War w/ Former FBI Agent John DeSouza
99.8K40 -
7:03:49
Dr Disrespect
21 hours ago🔴LIVE - DR DISRESPECT - NEW PC VS. DELTA FORCE - MAX SETTINGS
185K29 -
49:04
Lights, Camera, Barstool
1 day agoIs The Monkey The Worst Movie Of The Year?? + Amazon Gets Bond
85.7K5 -
24:19
Adam Carolla
1 day agoDiddy’s Legal Drama Escalates, Smuggler Caught Hiding WHAT? + Philly Eagles & The White House #news
173K22