Tag Archives: Excel Formulas

Short-circuiting Excel Formulas: IF, CHOOSE, IFS and SWITCH

Posted on January 3, 2023 by fastexcel

What is formula short-circuiting? Short-circuiting occurs in Excel formulas when an IF statement only evaluates the True part of the IF and skips the False part of the IF. For example in this formula: Because 1>2 evaluates to False the … Continue reading →

Posted in Calculation, Excel | Tagged , , | 3 Comments

Formula Explorer Pro Beta 4.2

Posted on January 8, 2019 by fastexcel

After another 6 months on my quest to create the worlds best tool for exploring, validating, debugging and editing Excel formulas I have made Explorer Pro Beta 4.2 build 418.796 available. Hopefully this will be the final Beta! The improvements … Continue reading →

Posted in Calculation, Debug formulas | Tagged , , , | 7 Comments

Writing Efficient VBA UDFs Part 14: Handling whole columns using Implicit Intersection – Updated

Posted on October 3, 2016 by fastexcel

Excel has an interesting and very efficient trick called Implicit Intersection which allows you to use large Named Ranges and whole column references efficiently. What is Implicit Intersection? When Excel expects to get a single cell reference but you give … Continue reading →

Posted in arrays, Calculation, UDF, VBA, XLL | Tagged , , , , | 15 Comments

Excel Circular References: Calculation, Detection, Control and Removal

Posted on September 14, 2015 by fastexcel

Circular references in Excel are generally bad news: They are slow to calculate They can be hard to detect An intentional circular reference can mask an unintended circular reference, They do not always converge The Status Bar always shows calculate … Continue reading →

Posted in Calculation | Tagged , , , | Leave a comment

Timing Excel Formula Calculations

Posted on May 11, 2015 by fastexcel

I have written a couple of posts previously about the methodology of timing Excel calculations: A Quantum of Time – measuring time accurately The XIPS Challenge – how fast does Excel calculate? But rather than focus exclusively on how to … Continue reading →

Posted in Calculation, Uncategorized | Tagged , , , | 3 Comments

Stacking (Appending) Arrays/Ranges in Excel: Formulas versus Functions Shootout

Posted on January 16, 2015 by fastexcel

This post is a follow up to my last post Using Constant Arrays and Expressions in Excel Formulas. I will explore how some of the general purpose array-handling functions in FastExcel SpeedTools Extras compare with formulas using native Excel functions. … Continue reading →

Posted in arrays, Calculation, Lookups, Uncategorized, XLL | Tagged , , , , , , , | 9 Comments