Function: CODE

Function: CODE

The Excel CODE function is a Text formula that converts a specified character into the corresponding code based on the character set used by your computer. This can be useful for when you want to find out the code for a specific character, or using this...

Function: CHAR

Function: CHAR

The Excel CHAR formula is a Text function that returns a character, based on the character set used by your computer. In this guide, we’re going to show you how to use the Excel CHAR function and also go over some tips and error handling methods. Supported...

Function: IFNA

Function: IFNA

The IFNA Excel formula is a Logical function that checks whether the reference contains an #N/A (not applicable) error. If the value is an #N/A error, the function returns a specified value; otherwise returns the value itself. In this guide, we’re going to...

Function: ISNA

Function: ISNA

ISNA Excel function is an Information formula that checks whether the specified value is an #N/A (not applicable) error. The function returns a Boolean value - TRUE if there is an #N/A error, and FALSE if not. In this guide, we’re going to show you how to...

Function: ISFORMULA

Function: ISFORMULA

The ISFORMULA is a Lookup & Reference function that checks whether the specified reference contains a formula. The function returns a Boolean value based on the outcome - TRUE if there is a formula, and FALSE if not. In this guide, we’re going to show...

Function: FORMULATEXT

Function: FORMULATEXT

The FORMULATEXT function returns the formula of a specified reference as a string. In this guide, we’re going to show you how to use FORMULATEXT function and also go over some tips and error handling methods. Supported versionsExcel 2013 and...

Function: PRODUCT

Function: PRODUCT

The PRODUCT function is a Math & Trig formula that returns the product of all numbers entered as its arguments. In this guide, we’re going to show you how to use PRODUCT function and also go over some tips and error handling methods. Supported...

Function: SUMPRODUCT

Function: SUMPRODUCT

The SUMPRODUCT Excel formula is a Math & Trig function that multiplies the values in arrays, and returns the sum of products. Although this sounds like something you could do using a combination of the SUM and the PRODUCT formulas, there is more to it!...

Function: MIN

Function: MIN

The Excel MIN function returns the minimum value in an array or range of cells. In this guide, we’re going to show you how to use the MIN function and also throw in some tips and error handling methods.Supported versionsAll Excel versionsExcel MIN Function...