STOP using nested IF statements! Use these functions instead.

Excel Off The Grid • September 26, 2024

Excel Off The Grid

About

Excel Off The Grid will show you how to work smarter, not harder with Microsoft Excel. Visit my website: https://exceloffthegrid.com

Latest Posts

Excel Functions That Behave Like Values - This Is Mind Blowing 🤯

Excel Off The Grid

Using Flexible Functions in Excel (only for advanced users).

Excel Off The Grid

Ultimate XLOOKUP Guide: 10 Tips You Need to Know!

Excel Off The Grid

How to automate Excel with reusable Office Scripts | Excel Off The Grid

Excel Off The Grid

Upgrade Your Tech Today

AI-recommended products based on this video

Best Seller

IFEART 70W USB C Charger for MacBook Air MacBook Pro 13 14 15 16 inch 2025 2024 2023 2022 2021 2020 2019 2018, M1 M2 M3 M4 Laptop USB C Power Adapter, 6.6ft USB C to C Cable, Original Quality

(4,167)

$29.99

FREE delivery Sat, Jun 14 on your first order

1K+ bought in past month

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods Global Recycled Standard

(30,415)

$30.39

Prime

1K+ bought in past month

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods (Blue) Global Recycled Standard

(27,328)

$39.99

PrimeFREE delivery Sat, Jun 14

100+ bought in past month

Apple 2025 MacBook Air 13-inch Laptop with M4 chip: Built for Apple Intelligence, 16GB Unified Memory, 256GB SSD Storage, Touch ID; Sky Blue - English Keyboard

(687)

$1,249.99

PrimeFREE delivery Sat, Jun 14

100+ bought in past month

Apple iPad with A16 chip: 11-inch Liquid Retina Display, 128 GB, Wi-Fi 6, 12MP Front/12MP Back Camera, Touch ID, All-Day Battery Life — Silver

(513)

$429.00

FREE delivery Sun, Aug 24

2K+ bought in past month

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods Global Recycled Standard

(30,415)

$30.39

Prime

1K+ bought in past month

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods (Blue) Global Recycled Standard

(27,328)

$39.99

PrimeFREE delivery Sat, Jun 14

100+ bought in past month

Wireless Charger for iPhone- 3 in 1 Charging Station for iPhone 16/15/14/13/12/Pro Max/Pro/Mini/Plus, Apple Watch 10/9/8/7/SE/6/5/4/3/2/1/Ultra2/Ultra, AirPods pro/2/3/4

(27)

$27.99

FREE delivery Sat, Jun 14 on your first order

Magnetic Wireless Charger for iPhone - 3 in 1 Mag-Safe Charging Station for Multiple Devices Apple - Charger Stand Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus Airpods

(750)

$59.99

PrimeFREE delivery Sat, Jun 14

[Apple MFi Certified] Lightning to HDMI Adapter for iPhone, 1080P Digital AV Adapter iPhone HDMI Adapter Video HDMI Sync Screen Connector Compatible with iPhone 14/13/12/X/8 NO Need Power Supply

(431)

$15.29

FREE delivery Fri, Oct 3 on your first order

500+ bought in past month

Best Seller

Mcbazel Wii to HDMI Converter Output Video Audio Adapter for Wii (NTSC 480I, 480P, PAL 576I) -Support All Display Modes

(1,399)

$7.99

FREE delivery Tue, Jun 17 on your first order

500+ bought in past month

ABLEWE RCA to HDMI,AV to HDMI Converter, 1080P Mini RCA Composite CVBS Video Audio Converter Adapter Supporting PAL/NTSC for TV/PC/ PS3/ STB/Xbox VHS/VCR/Blue-Ray DVD Players

(49,258)

$16.14

Prime

1K+ bought in past month

SAMSUNG T7 4TB, Portable SSD, Grey, up to 1050MB/s, USB 3.2 Gen2, Gaming, Students & Professionals, External Solid State Drive (MU-PC4T0T/AM), Grey [Canada Version]

(35,672)

$449.97$389.00

FREE delivery Tue, Jun 17

200+ bought in past month

SAMSUNG T7 Shield 4TB, Portable Solid State Drive, up-to 1050MB/s, USB 3.2 Gen2, Rugged, IP65 Water & Dust Resistant, for Photographers, Creators and Gaming, (MU-PE4T0S/AM), Black [Canada Version]

(14,545)

$439.97$348.93

FREE delivery Tue, Jun 17

50+ bought in past month

Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black

(43,809)

$14.99$11.99

FREE delivery Mon, Sep 22 on your first order

1K+ bought in past month

Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)

$27.98$22.38

FREE delivery Tue, Oct 14 on your first order

500+ bought in past month

Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

(21,223)

$44.98

FREE delivery Tue, Oct 14

1K+ bought in past month

Best Seller

Logitech G502 HERO High Performance Wired Gaming Mouse, HERO 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC / Mac, Black

(54,445)

$49.98$44.98

FREE delivery Tue, Oct 14

1K+ bought in past month

Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)

$27.98$22.38

FREE delivery Tue, Oct 14 on your first order

500+ bought in past month

Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

(21,223)

$44.98

FREE delivery Tue, Oct 14

1K+ bought in past month

Anker 332 USB-C Hub (5-in-1) with 4K HDMI Display, 5Gbps - and 2 5Gbps USB-A Data Ports and for MacBook Pro, MacBook Air, Dell XPS, Lenovo Thinkpad, HP Laptops and More

(11,639)

$23.99

FREE delivery Sat, Jun 14 on your first order

1K+ bought in past month

Apple 2025 MacBook Air 13-inch Laptop with M4 chip: Built for Apple Intelligence, 16GB Unified Memory, 256GB SSD Storage, Touch ID; Sky Blue - English Keyboard

(687)

$1,249.99

PrimeFREE delivery Sat, Jun 14

100+ bought in past month

Air Tracker Tags 4 Pack, Bluetooth Tracker & Item Locator Work with Apple Find My (iOS Only), Replaceable Battery, Waterproof Smart Tag for Keys, Wallet, Suitcases

(231)

$49.99

FREE delivery Wed, Sep 24

Air Tracker Tags-4 Pack: Smart Bluetooth Tracker, Item Finder Works with Apple Find My (iOS Only) App, Trakcer Tag Locator for Keys, Luggage, Satchel, Backpack etc. (Not for Android Devices)

(441)

$49.99

FREE delivery Sat, Sep 13

2K+ bought in past month

HATALKIN Case Compatible with Apple AirTags Case Keychain Air tag Holder Air Tag Key Ring Cases Air Tags Protective Cover Airtag Key Chain Loop Holders Silicone for Luggage Dog Cat Pet Collar 4 Pack

(19,279)

$9.78

FREE delivery Mon, Aug 25 on your first order

1K+ bought in past month

Apple iPhone 16 Pro Silicone Case with MagSafe - Ultramarine

(131)

$49.99

PrimeFREE delivery Sat, Jun 14

Apple iPhone 16 Pro Max Silicone Case with MagSafe - Star Fruit

(85)

$49.99

FREE delivery Jun 20 - 21

LAYJOY Compatible with iPhone 16 Pro Case, Silicone Soft TPU Bumper and Transparent Hard PC Case [Anti Yellowing] [Shockproof] [Anti-Scratch] Slim Phone Cover for iPhone 16 Pro 6.3-Inch-Clear

(1,072)

$8.99

FREE delivery Sat, Jun 14 on your first order

ORNARTO Compatible with iPhone 16 Pro Case 6.3",Liquid Silicone 3 Layers Full Covered Soft Gel Rubber Phone Case,Shockproof Protective Cover 6.3 Inch with Anti-Scratch Microfiber Lining-Chalk Pink Global Recycled Standard

(1,165)

$14.99$6.86

FREE delivery Sat, Jun 14 on your first order

500+ bought in past month

JUNEBOX 4K Portable Monitor 15.6" 3840 * 2160 HDR Display, 500nits 8bit QHD USB-C HDMI Laptop Monitor, 16:9 IPS Eye Care External Second Screen for Mac PC Phone PS4/5 Xbox Switch

(2)

$269.00

FREE delivery Tue, Aug 12

Jhcztrk 17.3 Inch Portable Monitor HDMI Type-C Laptop Gaming Monitor, 1600X900 with Built-in Speakers and Tripod External Slim Travel Monitors Second Monitors for Mac Smartphone PS4/PS5/ Gaming

(32)

$161.69$161.68

FREE delivery Aug 11 - 13

JUNEBOX Portable Monitor 18.5" 1080p Display, 500nits 8bit QHD USB-C HDMI Laptop Monitor, 16:9 IPS Eye Care External Second Screen for Mac PC Phone PS4/5 Xbox Switch (18.5'' 1920 * 1080 100HZ)

(0)

$180.49

FREE delivery Mon, Aug 11

18.5 inch Portable Monitor, InnoView 100HZ 120% sRGB 1080P FHD IPS Large Portable Monitor for Laptop USB C HDMI HDR Gaming Monitor with Kickstand Travel Monitor for Mac PC Xbox PS4/5 Switch

(2,007)

$239.99

FREE delivery Wed, Aug 13

50+ bought in past month

STOP using nested IF statements! Use these functions instead.

Excel Off The Grid

About

Latest Posts

Excel Functions That Behave Like Values - This Is Mind Blowing 🤯

Using Flexible Functions in Excel (only for advanced users).

Ultimate XLOOKUP Guide: 10 Tips You Need to Know!

How to automate Excel with reusable Office Scripts | Excel Off The Grid

You May Also Like

Upgrade Your Tech Today

IFEART 70W USB C Charger for MacBook Air MacBook Pro 13 14 15 16 inch 2025 2024 2023 2022 2021 2020 2019 2018, M1 M2 M3 M4 Laptop USB C Power Adapter, 6.6ft USB C to C Cable, Original Quality

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max &amp; Apple Watch - Charging Stand Dock for AirPods Global Recycled Standard

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max &amp; Apple Watch - Charging Stand Dock for AirPods (Blue) Global Recycled Standard

Apple 2025 MacBook Air 13-inch Laptop with M4 chip: Built for Apple Intelligence, 16GB Unified Memory, 256GB SSD Storage, Touch ID; Sky Blue - English Keyboard

Apple iPad with A16 chip: 11-inch Liquid Retina Display, 128 GB, Wi-Fi 6, 12MP Front/12MP Back Camera, Touch ID, All-Day Battery Life — Silver

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max &amp; Apple Watch - Charging Stand Dock for AirPods Global Recycled Standard

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max &amp; Apple Watch - Charging Stand Dock for AirPods (Blue) Global Recycled Standard

Wireless Charger for iPhone- 3 in 1 Charging Station for iPhone 16/15/14/13/12/Pro Max/Pro/Mini/Plus, Apple Watch 10/9/8/7/SE/6/5/4/3/2/1/Ultra2/Ultra, AirPods pro/2/3/4

Magnetic Wireless Charger for iPhone - 3 in 1 Mag-Safe Charging Station for Multiple Devices Apple - Charger Stand Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus Airpods

[Apple MFi Certified] Lightning to HDMI Adapter for iPhone, 1080P Digital AV Adapter iPhone HDMI Adapter Video HDMI Sync Screen Connector Compatible with iPhone 14/13/12/X/8 NO Need Power Supply

Mcbazel Wii to HDMI Converter Output Video Audio Adapter for Wii (NTSC 480I, 480P, PAL 576I) -Support All Display Modes

ABLEWE RCA to HDMI,AV to HDMI Converter, 1080P Mini RCA Composite CVBS Video Audio Converter Adapter Supporting PAL/NTSC for TV/PC/ PS3/ STB/Xbox VHS/VCR/Blue-Ray DVD Players

SAMSUNG T7 4TB, Portable SSD, Grey, up to 1050MB/s, USB 3.2 Gen2, Gaming, Students &amp; Professionals, External Solid State Drive (MU-PC4T0T/AM), Grey [Canada Version]

SAMSUNG T7 Shield 4TB, Portable Solid State Drive, up-to 1050MB/s, USB 3.2 Gen2, Rugged, IP65 Water &amp; Dust Resistant, for Photographers, Creators and Gaming, (MU-PE4T0S/AM), Black [Canada Version]

Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech G502 HERO High Performance Wired Gaming Mouse, HERO 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC / Mac, Black

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Anker 332 USB-C Hub (5-in-1) with 4K HDMI Display, 5Gbps - and 2 5Gbps USB-A Data Ports and for MacBook Pro, MacBook Air, Dell XPS, Lenovo Thinkpad, HP Laptops and More

Apple 2025 MacBook Air 13-inch Laptop with M4 chip: Built for Apple Intelligence, 16GB Unified Memory, 256GB SSD Storage, Touch ID; Sky Blue - English Keyboard

Air Tracker Tags 4 Pack, Bluetooth Tracker &amp; Item Locator Work with Apple Find My (iOS Only), Replaceable Battery, Waterproof Smart Tag for Keys, Wallet, Suitcases

Air Tracker Tags-4 Pack: Smart Bluetooth Tracker, Item Finder Works with Apple Find My (iOS Only) App, Trakcer Tag Locator for Keys, Luggage, Satchel, Backpack etc. (Not for Android Devices)

HATALKIN Case Compatible with Apple AirTags Case Keychain Air tag Holder Air Tag Key Ring Cases Air Tags Protective Cover Airtag Key Chain Loop Holders Silicone for Luggage Dog Cat Pet Collar 4 Pack

Apple iPhone 16 Pro Silicone Case with MagSafe - Ultramarine ​​​​​​​

Apple iPhone 16 Pro Max Silicone Case with MagSafe - Star Fruit ​​​​​​​

LAYJOY Compatible with iPhone 16 Pro Case, Silicone Soft TPU Bumper and Transparent Hard PC Case [Anti Yellowing] [Shockproof] [Anti-Scratch] Slim Phone Cover for iPhone 16 Pro 6.3-Inch-Clear

ORNARTO Compatible with iPhone 16 Pro Case 6.3&quot;,Liquid Silicone 3 Layers Full Covered Soft Gel Rubber Phone Case,Shockproof Protective Cover 6.3 Inch with Anti-Scratch Microfiber Lining-Chalk Pink Global Recycled Standard

JUNEBOX 4K Portable Monitor 15.6&quot; 3840 * 2160 HDR Display, 500nits 8bit QHD USB-C HDMI Laptop Monitor, 16:9 IPS Eye Care External Second Screen for Mac PC Phone PS4/5 Xbox Switch

Jhcztrk 17.3 Inch Portable Monitor HDMI Type-C Laptop Gaming Monitor, 1600X900 with Built-in Speakers and Tripod External Slim Travel Monitors Second Monitors for Mac Smartphone PS4/PS5/ Gaming

JUNEBOX Portable Monitor 18.5&quot; 1080p Display, 500nits 8bit QHD USB-C HDMI Laptop Monitor, 16:9 IPS Eye Care External Second Screen for Mac PC Phone PS4/5 Xbox Switch (18.5&#x27;&#x27; 1920 * 1080 100HZ)

18.5 inch Portable Monitor, InnoView 100HZ 120% sRGB 1080P FHD IPS Large Portable Monitor for Laptop USB C HDMI HDR Gaming Monitor with Kickstand Travel Monitor for Mac PC Xbox PS4/5 Switch

Loading...

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods Global Recycled Standard

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods (Blue) Global Recycled Standard

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods Global Recycled Standard

3 in 1 Charging Station for iPhone, Wireless Charger for iPhone 16 15 14 13 12 11 X Pro Max & Apple Watch - Charging Stand Dock for AirPods (Blue) Global Recycled Standard

SAMSUNG T7 4TB, Portable SSD, Grey, up to 1050MB/s, USB 3.2 Gen2, Gaming, Students & Professionals, External Solid State Drive (MU-PC4T0T/AM), Grey [Canada Version]

SAMSUNG T7 Shield 4TB, Portable Solid State Drive, up-to 1050MB/s, USB 3.2 Gen2, Rugged, IP65 Water & Dust Resistant, for Photographers, Creators and Gaming, (MU-PE4T0S/AM), Black [Canada Version]

Air Tracker Tags 4 Pack, Bluetooth Tracker & Item Locator Work with Apple Find My (iOS Only), Replaceable Battery, Waterproof Smart Tag for Keys, Wallet, Suitcases

Apple iPhone 16 Pro Silicone Case with MagSafe - Ultramarine

Apple iPhone 16 Pro Max Silicone Case with MagSafe - Star Fruit

ORNARTO Compatible with iPhone 16 Pro Case 6.3",Liquid Silicone 3 Layers Full Covered Soft Gel Rubber Phone Case,Shockproof Protective Cover 6.3 Inch with Anti-Scratch Microfiber Lining-Chalk Pink Global Recycled Standard

JUNEBOX 4K Portable Monitor 15.6" 3840 * 2160 HDR Display, 500nits 8bit QHD USB-C HDMI Laptop Monitor, 16:9 IPS Eye Care External Second Screen for Mac PC Phone PS4/5 Xbox Switch

JUNEBOX Portable Monitor 18.5" 1080p Display, 500nits 8bit QHD USB-C HDMI Laptop Monitor, 16:9 IPS Eye Care External Second Screen for Mac PC Phone PS4/5 Xbox Switch (18.5'' 1920 * 1080 100HZ)