Formulae blogs

Listing 12 FORMULAE blogs in the EXCEL category

A dedicated AI tool to help you to create your formulae in Excel

Posted by Andy Brown on 03 April 2024

The Ajelix Excel AI tool claims to help you generate formulae in Excel - so we put it to the test

Tags ==>
Excel > Formulae

ChatGPT embedded within an Excel workbook? What's not to like?

Posted by Andy Brown on 03 April 2024

How one determined person embedded the published ChatGPT 2 source code and weightings within an Excel workbook to give an insight into how AI works

Tags ==>
Excel > Formulae

The most complicated Excel formula ever?

Posted by Andy Brown on 07 June 2023

While browsing through forums (as one does) we found what must surely be the most complicated Excel formula. At 1,860 characters long - and combining some of the most complicated Excel functions - it's a true Excel monster. Unless you can do better?!

Tags ==>
Excel > Formulae

A new feature lets you show the value of part of a formula in Excel in a tooltip

Posted by Andy Brown on 25 April 2023

When you select part of a formula in Excel, a values preview tooltip now appears showing you what the results would be for this if you calculated it (removing the need for you to press the F9 key).

Tags ==>
Excel > Formulae

The hidden door to extra functions in Excel

Posted by Andy Brown on 15 September 2022

Did you know that you could combine range names and legacy Excel 4 functions to list out the worksheets or range names in your workbook - wthout using macros? I didn't either - here's how to do this, and much more!

Tags ==>
Excel > Formulae

Having fun with spill arrays (dynamic arrays) in Excel

Posted by Andy Brown on 02 September 2022

Four examples of using spill arrays to introduce elegance solutions into your spreadsheets.

Tags ==>
Excel > Formulae

How to build an Excel word search without even using VBA

Posted by Andy Brown on 23 February 2021

Details of an impressive new Excel word search system which allows you to recreate a randomised grid every time you recalculate your formulae!

Tags ==>
Excel > Formulae

Creating and using Lambda Functions in Excel

Posted by Andy Brown on 21 December 2020

You can now create and use anonymous functions in Excel (usually called "Lambda functions"). Learn how to add to the stock of Excel functions without having to learn any programming code!

Tags ==>
Excel > Formulae

You can use the new LET function in Excel to store interim formulae calculations

Posted by Andy Brown on 24 October 2020

The new Excel LET function lets you create variables to store the results of calculations, making formulae easier to read and quicker to calculate.

Tags ==>
Excel > Formulae

Why the Excel range name conflict dialog box appears, and how to avoid looping

Posted by Andy Brown on 14 June 2019

When you're copying worksheets containing range names, Excel can detect conflicts and take you into a seemingly endless loop of Yes/No dialog boxes. This blog explains why this happens, and how to get out of the loop!

Tags ==>
Excel > Formulae

How to refer to range names with worksheet and workbook scope

Posted by Andy Brown on 01 November 2013

Range names can have either worksheet or workbook scope - this blog shows how to make sure that you're referring to the right range names!

Tags ==>
Excel > Formulae

Using Range Names in Excel

Posted by Andrew Gould on 22 August 2011

Did you know that you don't have to use cell references in calculations in Microsoft Excel? You can use range names to create sensible, plain English names to refer to your cells and use those in your formulae instead. Read this blog to find out how.