Function: LAMBDA

Function: LAMBDA

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...
Function: WORKDAY.INTL

Function: WORKDAY.INTL

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...
Function: WORKDAY

Function: WORKDAY

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...
Function: UNICODE

Function: UNICODE

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...
Function: XMATCH

Function: XMATCH

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....
Function: XLOOKUP

Function: XLOOKUP

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...
Function: LET

Function: LET

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....
Function: DEC2HEX

Function: DEC2HEX

The DEC2HEX is an Engineering function that converts a hexadecimal number into a decimal number. In this guide, we’re going to show you how to use the DEC2HEX function and also go over some tips and error handling methods. Supported versions All Excel versions DEC2HEX...