Unfortunately, if you're using Excel 2019 or earlier, you won't be able to create your own functions using the methods described in this guide.

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel for the web.

The difference between the LOG and LOG10 functions in Microsoft Excel is that LOG returns the logarithm of a number to the base you specify, and LOG10 returns the base -10 logarithm of a number.

Excel also has a ton of pre-made functions to do more complex math for you. For example, say you want to find out how much money the X-Men films have made globally on average in the above spreadsheet.

Learn how to use MINVERSE and MMULT functions in Excel. MINIVERSE returns the matrix inverse of an array,. MMULT function returns matrix product of two arrays.

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

How to Use Trig Functions in Excel. Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic ...

Learn how to use the powerful Excel TREND and FORECAST functions in your spreadsheets for more insight and analyze data more effectively ...