IF, IFS, Nested IFs: Avoid the Mistakes Slowing You Down

MyOnlineTrainingHub June 23, 2021
Video Thumbnail
MyOnlineTrainingHub Logo

MyOnlineTrainingHub

@myonlinetraininghub

About

Teaching you Excel and Power BI skills that will get you noticed and promoted. For more, check out my courses here: https://www.myonlinetraininghub.com/courses

Video Description

IF function tutorial in Excel: IF, nested IFs, IFS, etc. Performance issues with solutions. 👩‍🏫 Master Excel with my courses: https://bit.ly/iffunction24courses ➡️ Download the example file here: https://bit.ly/iffunction24file ➡️ Use our IF Formula Builder: https://www.myonlinetraininghub.com/if-formula-builder IF Statements are essential for all Excel users to master. Unfortunately, many get stuck with nesting and make mistakes that can cause performance issues, which I address in this video. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 Excel IF Formulas 1:39 Nested IF Formulas 3:14 Excel IFS Function 4:24 Mistakes that cause performance issues 6:04 VLOOKUP Alternative 7:52 XLOOKUP Alternative #Excel #ExcelFunctions #ExcelFormulas

You May Also Like

Boost Your Coding Efficiency Today

AI-recommended products based on this video

Loading...
Nintendo Switch Mario Kart Racing Wheel Pro Deluxe by HORI - Officially Licensed by Nintendo - Deluxe Edition

Nintendo Switch Mario Kart Racing Wheel Pro Deluxe by HORI - Officially Licensed by Nintendo - Deluxe Edition

(3,913)
$152.85
PrimeFREE delivery Sat, Jun 14
Loading...
msi Crosshair 16 Gaming Laptop - with 2024 Office Lifetime License, GeForce RTX 4070, 16" FHD+ 144 Hz Display, 14th Gen Intel 16-Core i7 14650HX, Backlit KB, Windows 11 Pro (32GB DDR5 RAM | 1TB SSD)

msi Crosshair 16 Gaming Laptop - with 2024 Office Lifetime License, GeForce RTX 4070, 16" FHD+ 144 Hz Display, 14th Gen Intel 16-Core i7 14650HX, Backlit KB, Windows 11 Pro (32GB DDR5 RAM | 1TB SSD)

(0)
$7,606.98
FREE delivery Jun 23 - Jul 3Only 3 left in stock.
Loading...
Clip in Hair Tinsel, Clips on Hair Tensile Champagne Gold, Pack of 12Pcs, 20 inch Glitter Tinsel Extensions, Festival Fairy (Champagne)

Clip in Hair Tinsel, Clips on Hair Tensile Champagne Gold, Pack of 12Pcs, 20 inch Glitter Tinsel Extensions, Festival Fairy (Champagne)

(0)
$16.95
$7.95 delivery Jan 7 - 16
Loading...
10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

(1)
$99.99
FREE delivery Mon, Aug 11
Loading...
VersionTECH. Gaming Mouse Ergonomic Wired Computer Mouse with 7 Colors LED Backlight, 4 DPI Settings Up to 3600 DPI Compatible for Chromebook Windows 7/8/10/11 XP/Mac/Linux Gamer/Notebook/MacBook
Best Seller

VersionTECH. Gaming Mouse Ergonomic Wired Computer Mouse with 7 Colors LED Backlight, 4 DPI Settings Up to 3600 DPI Compatible for Chromebook Windows 7/8/10/11 XP/Mac/Linux Gamer/Notebook/MacBook

(15,947)
$12.79
FREE delivery Thu, Sep 11 on your first order
500+ bought in past month
Loading...
LODVIE Wireless Mouse for Laptop,2400 DPI Wireless Computer Mouse with 6 Buttons,2.4G Ergonomic USB Cordless Mouse,15 Months Battery Life Mouse for Laptop PC Mac Computer Chromebook MacBook-Black

LODVIE Wireless Mouse for Laptop,2400 DPI Wireless Computer Mouse with 6 Buttons,2.4G Ergonomic USB Cordless Mouse,15 Months Battery Life Mouse for Laptop PC Mac Computer Chromebook MacBook-Black

(7,870)
$14.99
Prime
2K+ bought in past month
Loading...
Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Noise-Cancelling Mic and LED Display, Built-in Mic for Clear Calls, Waterproof Design for Sports

Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Noise-Cancelling Mic and LED Display, Built-in Mic for Clear Calls, Waterproof Design for Sports

(8)
$39.99
FREE delivery Tue, Nov 4
Loading...
Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Powerful Bass, Built-in Noise-Cancelling Mic for Clear Calls, LED Display, 36H Playtime, IPX5 Waterproof Design for Sports

Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Powerful Bass, Built-in Noise-Cancelling Mic for Clear Calls, LED Display, 36H Playtime, IPX5 Waterproof Design for Sports

(40)
$39.99
FREE delivery Thu, Nov 13