Excel Functions

We use Formulas & function to be calculation on the basis of requirement. It works for simple and complex both requirements. A formula can contain values, references, defined names and functions.

Formulas & Functions are little different with each other. When we use one Excel in-built function in a cell such as Sum() function we called it function and when we use bunch of function to solve our purpose we called it formulas.

100+ Excel Functions

FunctionsDescription
LEN FunctionExcel LEN function can be used when you want to get the total number of characters in a specified string.
MID FunctionExcel MID function can be used to extract a specified number of characters from a string.
FIND FunctionExcel FIND function can be used when you want to locate a text string within another text string and find its position
LEFT FunctionExcel LEFT function can be used to extract text from left of the string.
REPT FunctionExcel REPT function can be used when you want to repeat a specified text for a certain number of times.
TEXT FunctionExcel TEXT function can be used when you want to convert a number to text format and display it in a specified format
TRIM FunctionExcel TRIM function can be used when you want to remove leading, trailing, and double spaces in Excel.
LOWER FunctionExcel LOWER function can be used when you want to convert all uppercase letter in a text string to lowercase.
UPPER FunctionExcel UPPER function can be used when you want to convert all lowercase letter in a text string to uppercase.
RIGHT FunctionRIGHT function can be used to extract text from the right of the string.
CLEAN FunctionRemoves all non-printable characters from a supplied text string
EXACT FunctionTests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive)
VALUE FunctionConverts a text string into a numeric value
PROPER FunctionExcel PROPER function can be used when you want to capitalize the first character of every word.
SEARCH FunctionExcel SEARCH function can be used when you want to locate a text string within another text string and find its position.
REPLACE FunctionExcel REPLACE function can be used when you want to replace a part of the text string with another string.
SUBSTITUTE FunctionExcel SUBSTITUTE function can be used when you want to substitute text with new specified text in a string.
CONCATENATE FunctionExcel CONCATENATE function can be used when you want to join 2 or more characters or strings.
FunctionsDescription
DAY FunctionExcel DAY function can be used when you want to get the day value (ranging between 1 to 31) from a specified date.
NOW FunctionExcel NOW function can be used to get the current date and time value.
DATE FunctionExcel DATE function can be used when you want to get the date value using the year, month and, day values as the input arguments.
HOUR FunctionExcel HOUR function can be used when you want to get the HOUR integer value from a specified time value.
DAYS FunctionDAYS function calculate the number of days between two dates
YEAR FunctionYEAR function return the number of year from a date
TIME FunctionTIME function we use to convert the given number as hour, minute and seconds in an Excel serial number, formatted with a time format
TODAY FunctionExcel TODAY function can be used to get the current date.
EDATE FunctionEDATE function helps to return the serial number of the date that is indicated the number of month before or after the start date.
MONTH FunctionMONTH function return the number of month from a date
MINUTE FunctionExcel MINUTE function can be used when you want to get the MINUTE integer value from a specified time value.
SECOND FunctionExcel SECOND function can be used want to get the integer value of the seconds from a specified time value.
WEEKDAY FunctionExcel WEEKDAY function can be used to get the day of the week as a number (between 1 to 7) for the specified date.
WORKDAY FunctionExcel WORKDAY function can be used when you want to get the date after a given number of working days.
DATEDIF FunctionExcel DATEDIF function can be used when you want to calculate the number of years, months, or days between the two specified dates. A good example would be calculating the age.
EOMONTH FunctionEOMONTH function can be used to return the serial number of the last day of the month before or after a specified number of months
DATEVALUE FunctionExcel DATEVALUE function is best suited for situations when a date is stored as text. This function converts the date from text format to a serial number that Excel recognizes as a date.
NETWORKDAYS FunctionExcel NETWORKDAYS function can be used when you want to get the number of working days between two given dates.
WORKDAY.INTL FunctionExcel WORKDAY.INTL function can be used when you want to get the date after a given number of working days.
NETWORKDAYS.INTL FunctionExcel NETWORKDAYS.INTL function can be used when you want to get the number of working days between two given dates.
FunctionsDescription
OR FunctionExcel OR function can be used when you want to check multiple conditions.
IF FunctionExcel IF Function is best suited for situations where you want to evaluate a condition, and the return a value if it is TRUE and another value if it is FALSE.
AND FunctionExcel AND function can be used when you want to check multiple conditions.
NOT FunctionExcel NOT function can be used when you want to reverse the value of a logical argument (TRUE/FALSE).
XOR FunctionXOR function helps to return a logical ‘Exclusive Or’ of all arguments
IFERROR FunctionExcel IFERROR function is best-suited to handle formula that evaluates to an error.
FunctionsDescription
ROW FunctionExcel ROW Function function can be used when you want to get the row number of a cell reference.
ROWS FunctionExcel ROWS Function can be used when you want to get the number of rows in a specified range or array.
INDEX FunctionExcel INDEX function can be used when you have the position (row number and column number) of a value in a table, and you want to fetch that value.
MATCH FunctionExcel MATCH function can be used when you want to get the relative position of a lookup value in a list or an array.
COLUMN FunctionExcel COLUMN function can be used when you want to get the column number of a specified cell.
OFFSET FunctionExcel OFFSET function can be used when you want to get a reference which offsets specified number of rows and columns from the starting point.
CHOOSE FunctionCHOOSE function can be used to chooses a value or action to perform a list of values, based on an index number
LOOKUP FunctionLOOKUP function we use to looks up a value either from a one-row or one-column range or from an array. Provided for backward compatibility
COLUMNS FunctionExcel COLUMNS function can be used when you want to get the number of columns in a specified range or array.
HLOOKUP FunctionExcel HLOOKUP function is best suited for situations when you are looking for a matching data point in a row, and when the matching data point is found, you go down that column and fetch a value from a cell which is specified a number of rows below the top row.
VLOOKUP FunctionExcel VLOOKUP function is best suited for situations when you are looking for a matching data point in a column, and when the matching data point is found, you go to the right in that row and fetch a value from a cell which is a specified number of columns to the right.
INDIRECT FunctionExcel INDIRECT function can be used when you have the references as text and you want to get the values from those references.
HYPERLINK FunctionHYPERLINK function use to create a shortcut or jump that opens a document stored on your hard drive, a network server or on the internet
TRANSPOSE FunctionTRANSPOSE function use to convert a vertical range of cells to a horizontal range or horizontal range into vertical range
FunctionsDescription
INT FunctionExcel INT Function can be used when you want to get the integer portion of a number.
MOD FunctionExcel MOD function can be used when you want to get the remainder when one number is divided by another.
SUM FunctionExcel SUM function can be used to add all numbers in a range of cells.
RAND FunctionExcel RAND function can be used when you want to generate evenly distributed random numbers between 0 and 1
ROUND FunctionExcel ROUND function can be used when you want to return a number rounded to a specified number of digits.
SUMIF FunctionExcel SUMIF function can be used when you want to add the values in a range if the specified condition is met.
POWER FunctionReturns the result of a given number raised to a supplied power
SUMIFS FunctionExcel SUMIFS function can be used when you want to add the values in a range if multiple specified criteria are met.
MROUND FunctionRounds a number up or down, to the nearest multiple of significance
ROUNDUP FunctionRounds a number away from zero (ie. rounds a positive number up and a negative number down), to a given number of digits
PRODUCT FunctionReturns the product of a supplied list of numbers
SUBTOTAL FunctionPerforms a specified calculation (eg. the sum, product, average, etc.) for a supplied set of values
ROUNDDOWN FunctionRounds a number towards zero, (ie. rounds a positive number down and a negative number up), to a given number of digits
SUMPRODUCT FunctionExcel SUMPRODUCT function can be used when you want to first multiply two or more sets to arrays and then get its sum
RANDBETWEEN FunctionExcel RANDBETWEEN function can be used when you want to generate evenly distributed random numbers between a top and bottom range specified by the user.
FunctionsDescription
MAX FunctionExcel MAX function can be used when you want to get the largest value from a set of values.
MIN FunctionExcel MIN function can be used when you want to get the smallest value from a set of values.
RANK FunctionExcel RANK function can be used when you want to rank a number against a list of numbers.
COUNT FunctionExcel COUNT function can be used to count the number of cells that contain numbers.
LARGE FunctionExcel LARGE function can be used to get the Kth largest value from a range of cells or array. For example, you can get the 3rd largest value from a range of cells.
LARGE FunctionReturns the Kth LARGEST value from a list of supplied numbers, for a given value K
SMALL FunctionExcel SMALL function can be used to get the Kth smallest value from a range of cells or array.
COUNTA FunctionExcel COUNTA function can be used when you want to count all the cells in a range that are not empty.
MEDIAN FunctionReturns the Median (the middle value) of a list of supplied numbers
AVERAGE FunctionExcel AVERAGE function can be used when you want to get the average (arithmetic mean) of the specified arguments.
COUNTIF FunctionExcel COUNTIF function can be used when you want to count the number of cells that meet specified criteria.
COUNTIFS FunctionExcel COUNTIFS function can be used when you want to count the number of cells that meet a single or multiple criteria.
AVERAGEIF FunctionExcel AVERAGEIF function can be used when you want to get the average (arithmetic mean) of all the values in a range of cells that meet a given criteria.
FREQUENCY FunctionReturns an array showing the number of values from a supplied array, which fall into specified ranges
AVERAGEIFS FunctionExcel AVERAGEIFS function can be used when you want to get the average (arithmetic mean) of all the cells in a range that meets multiple criteria.
COUNTBLANK FunctionExcel COUNTBALNK function can be used when you have to count all the empty cells in a range.
FunctionsDescription
ISNA FunctionExcel ISNA function returns TRUE when specified condition is TRUE. For example, ISNA would return TRUE if the cell has a #N/A! error.
ISTEXT FunctionISTEXT function checks whether supplied cell value is text, it returns TRUE or FALSE
ISBLANK FunctionISBLANK function is use to check whether cell reference is to empty, and returns TRUE or FALSE
ISERROR FunctionISERROR function we use to check that supplied cell reference is having error or not. Function returns TRUE or FALSE
ISNUMBER FunctionISNUMBER function checks whether supplied cell value is number , it returns TRUE or FALSE
ISLOGICAL FunctionISLOGICAL function can be used to check for the logical value for the supplied cell reference