


Excel Function Replace

EXCEL FUNCTION – SMALL
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k

EXCEL FUNCTION – LARGE
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k

EXCEL FUNCTION – COUNTBLANK
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.

EXCEL FUNCTION – COUNTA
COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2

EXCEL FUNCTION – COUNT
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.

EXCEL FUNCTION – AVERAGEIFS
AVERAGEIFS function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.

EXCEL FUNCTION – AVERAGEIF
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.

EXCEL FUNCTION – AVERAGE
AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.

EXCEL FUNCTION – RANK
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank

EXCEL FUNCTION – SUMPRODUCT
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.

EXCEL FUNCTION – ROUND
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits

EXCEL FUNCTION – MATCH
MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments

EXCEL FUNCTION – MIN
MIN function is used to get the smallest number in range or list of values.MIN function has one required i.e. number1 and optional argument i.e. [number2]

EXCEL FUNCTION – MAX
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1

EXCEL FUNCTION – MOD
MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.

EXCEL FUNCTION – INT
INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.

EXCEL FUNCTION – ROWS
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.

EXCEL FUNCTION – ROW
ROW function is used to get the row reference number of the excel worksheet. ROW Function has only one argument i.e. reference,

EXCEL FUNCTION – INDIRECT
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.