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

Function: HEX2DEC

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

Function: CELL

The CELL is an Information function that returns information about various properties of a cell. You can learn things like file name with full folder path, location of a cell or formatting properties. In this guide, we’re going to show you how to use the CELL function...
Function: YEARFRAC

Function: YEARFRAC

The YEARFRAC is a Date & Time function that calculates and returns the fraction of the year between two days. The function calculates the fraction by the number of whole days in given day count basis. In this guide, we’re going to show you how to use the YEARFRAC...
STANDARDIZE Function

STANDARDIZE Function

The STANDARDIZE Excel function is a Statistical formla that calculates and returns normalized value (z-score) based on the mean and standard deviation of a data set. In this guide, we’re going to show you how to use the STANDARDIZE function and also go over some tips...
RANK.AVG (RANK AVG) Function in Excel

RANK.AVG (RANK AVG) Function in Excel

RANK.AVG (RANK AVG) is a Statistical function that can return the rank of a given value, within the specified array of values. If there are values that share the same rank, the average rank of that set of values will be returned. In this guide, we’re going to show you...