by Ilker | Jan 26, 2021 | Excel Formulas
FREQUENCY is a Statistical function that can calculate how often values occur in a set of data and returns the occurrence counts as a vertical array. These numbers represent frequencies can be helpful for charting histograms. In this guide, we’re going to show you how...
by Ilker | Jan 22, 2021 | Excel Formulas
LAMBDA is a special function that can create custom functions in the scope of a named range. You can essentially create a user defined function without any VBA, macro, or JavaScript knowledge. In this guide, we’re going to show you how to use the LAMBDA function and...
by Ilker | Jan 19, 2021 | Excel Formulas, Uncategorized
The PI function is a Math and Trigonometry formula that returns the equivalent value for the mathematical constant pi (π), which is commonly used in finding the diameter or volume of circles and spherical objects. In this guide, we’re going to show you how to use the...
by Ilker | Jan 18, 2021 | Excel Formulas
The WORKDAY.INTL is a Date & Time function that can add or subtract the number of workdays from a given date. As the name suggests, the function is a modified version of the WORKDAY function which you can incorporate weekends and holidays in your calculations. In...
by Ilker | Jan 15, 2021 | Excel Formulas
WORKDAY is a Date & Time function that can add or subtract the number of workdays from a given date. In this guide, we’re going to show you how to use the WORKDAY function and also go over some tips and error handling methods. Supported versions Excel 2007 and...
by Ilker | Jan 15, 2021 | Excel Formulas
UNICODE is a Text function that returns a corresponding numeric code of a Unicode character. Unicode is a character set, like ASCII. However, it contains characters from different languages, scripts and symbols, including ASCII characters. Each character has its own...
by Ilker | Jan 8, 2021 | Excel Formulas
The XMATCH function is a Lookup & Reference function that returns the relative position of a lookup value from a specified array or range. In this guide, we’re going to show you how to use the XMATCH function and also go over some tips and error handling methods....
by Ilker | Jan 7, 2021 | Excel Formulas
The XLOOKUP function is a Lookup & Reference function that can find values in a table or a range by row. Similar to the better-known VLOOKUP function, you can use this function to do things like looking up the name or price of a product by its code number. In this...
by Ilker | Dec 15, 2020 | Excel Formulas
The LET function can define names within the scope of a formula. This essentially offers better readability and help with calculation performance. In this guide, we are going to show you how to use the LET function and go over some tips and error handling methods....
