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.
EXCEL FUNCTION – SUMIFS
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
