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 versions Excel 2013 and later FORMULATEXT Syntax...
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 versions All Excel...
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! Thanks to...
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 versions All Excel versions Excel MIN Function Syntax...
Function: MAX

Function: MAX

The Excel MAX function returns the maximum value in an array or range of cells. In this guide, we’re going to show you how to use the MAX function and also throw in some tips and error handling methods. Supported versions All Excel versions Excel MAX Function Syntax...
Function: COLUMNS

Function: COLUMNS

The Excel COLUMNS function returns the number of columns in a selection. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax SUMIF(range, criteria,...
Function: ROWS

Function: ROWS

The Excel ROWS function is a Lookup & Reference formula that returns the number of rows in an array, an array formula, or a range of cells. In this guide, we’re going to show you how to use the Excel ROWS function and also go over some tips and error handling...
Function: COLUMN

Function: COLUMN

The Excel COLUMN function is a Lookup & Reference formula that returns the column number of a reference. In this guide, we’re going to show you how to use the Excel COLUMN function and also go over some tips and error handling methods. Supported versions All Excel...
Function: ROW

Function: ROW

The Excel ROW function is a Lookup & Reference formula that returns the row number of a reference. In this guide, we’re going to show you how to use the Excel ROW function and also go over some tips and error handling methods. Supported versions All Excel versions...