Excel Function – WEEKNUM Function
Watch Excel Tutorial Video - Excel Function – WEEKNUM Function WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and...
Excel Function Replace
How to use “REPLACE” function in Excel REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num,...
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.