# 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

 Functions Description LEN Function Excel LEN function can be used when you want to get the total number of characters in a specified string. MID Function Excel MID function can be used to extract a specified number of characters from a string. FIND Function Excel FIND function can be used when you want to locate a text string within another text string and find its position LEFT Function Excel LEFT function can be used to extract text from left of the string. REPT Function Excel REPT function can be used when you want to repeat a specified text for a certain number of times. TEXT Function Excel TEXT function can be used when you want to convert a number to text format and display it in a specified format TRIM Function Excel TRIM function can be used when you want to remove leading, trailing, and double spaces in Excel. LOWER Function Excel LOWER function can be used when you want to convert all uppercase letter in a text string to lowercase. UPPER Function Excel UPPER function can be used when you want to convert all lowercase letter in a text string to uppercase. RIGHT Function RIGHT function can be used to extract text from the right of the string. CLEAN Function Removes all non-printable characters from a supplied text string EXACT Function Tests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive) VALUE Function Converts a text string into a numeric value PROPER Function Excel PROPER function can be used when you want to capitalize the first character of every word. SEARCH Function Excel SEARCH function can be used when you want to locate a text string within another text string and find its position. REPLACE Function Excel REPLACE function can be used when you want to replace a part of the text string with another string. SUBSTITUTE Function Excel SUBSTITUTE function can be used when you want to substitute text with new specified text in a string. CONCATENATE Function Excel CONCATENATE function can be used when you want to join 2 or more characters or strings.

## Date & Time Functions

 Functions Description DAY Function Excel DAY function can be used when you want to get the day value (ranging between 1 to 31) from a specified date. NOW Function Excel NOW function can be used to get the current date and time value. DATE Function Excel 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 Function Excel HOUR function can be used when you want to get the HOUR integer value from a specified time value. DAYS Function DAYS function calculate the number of days between two dates YEAR Function YEAR function return the number of year from a date TIME Function TIME function we use to convert the given number as hour, minute and seconds in an Excel serial number, formatted with a time format TODAY Function Excel TODAY function can be used to get the current date. EDATE Function EDATE function helps to return the serial number of the date that is indicated the number of month before or after the start date. MONTH Function MONTH function return the number of month from a date MINUTE Function Excel MINUTE function can be used when you want to get the MINUTE integer value from a specified time value. SECOND Function Excel SECOND function can be used want to get the integer value of the seconds from a specified time value. WEEKDAY Function Excel WEEKDAY function can be used to get the day of the week as a number (between 1 to 7) for the specified date. WORKDAY Function Excel WORKDAY function can be used when you want to get the date after a given number of working days. DATEDIF Function Excel 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 Function EOMONTH 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 Function Excel 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 Function Excel NETWORKDAYS function can be used when you want to get the number of working days between two given dates. WORKDAY.INTL Function Excel WORKDAY.INTL function can be used when you want to get the date after a given number of working days. NETWORKDAYS.INTL Function Excel NETWORKDAYS.INTL function can be used when you want to get the number of working days between two given dates.

## Logical Functions

 Functions Description OR Function Excel OR function can be used when you want to check multiple conditions. IF Function Excel 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 Function Excel AND function can be used when you want to check multiple conditions. NOT Function Excel NOT function can be used when you want to reverse the value of a logical argument (TRUE/FALSE). XOR Function XOR function helps to return a logical ‘Exclusive Or’ of all arguments IFERROR Function Excel IFERROR function is best-suited to handle formula that evaluates to an error.

## Lookup Functions

 Functions Description ROW Function Excel ROW Function function can be used when you want to get the row number of a cell reference. ROWS Function Excel ROWS Function can be used when you want to get the number of rows in a specified range or array. INDEX Function Excel 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 Function Excel MATCH function can be used when you want to get the relative position of a lookup value in a list or an array. COLUMN Function Excel COLUMN function can be used when you want to get the column number of a specified cell. OFFSET Function Excel 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 Function CHOOSE function can be used to chooses a value or action to perform a list of values, based on an index number LOOKUP Function LOOKUP 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 Function Excel COLUMNS function can be used when you want to get the number of columns in a specified range or array. HLOOKUP Function Excel 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 Function Excel 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 Function Excel INDIRECT function can be used when you have the references as text and you want to get the values from those references. HYPERLINK Function HYPERLINK 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 Function TRANSPOSE function use to convert a vertical range of cells to a horizontal range or horizontal range into vertical range

## Math & Trig Functions

 Functions Description INT Function Excel INT Function can be used when you want to get the integer portion of a number. MOD Function Excel MOD function can be used when you want to get the remainder when one number is divided by another. SUM Function Excel SUM function can be used to add all numbers in a range of cells. RAND Function Excel RAND function can be used when you want to generate evenly distributed random numbers between 0 and 1 ROUND Function Excel ROUND function can be used when you want to return a number rounded to a specified number of digits. SUMIF Function Excel SUMIF function can be used when you want to add the values in a range if the specified condition is met. POWER Function Returns the result of a given number raised to a supplied power SUMIFS Function Excel SUMIFS function can be used when you want to add the values in a range if multiple specified criteria are met. MROUND Function Rounds a number up or down, to the nearest multiple of significance ROUNDUP Function Rounds a number away from zero (ie. rounds a positive number up and a negative number down), to a given number of digits PRODUCT Function Returns the product of a supplied list of numbers SUBTOTAL Function Performs a specified calculation (eg. the sum, product, average, etc.) for a supplied set of values ROUNDDOWN Function Rounds a number towards zero, (ie. rounds a positive number down and a negative number up), to a given number of digits SUMPRODUCT Function Excel SUMPRODUCT function can be used when you want to first multiply two or more sets to arrays and then get its sum RANDBETWEEN Function Excel RANDBETWEEN function can be used when you want to generate evenly distributed random numbers between a top and bottom range specified by the user.

## Statistical Functions

 Functions Description MAX Function Excel MAX function can be used when you want to get the largest value from a set of values. MIN Function Excel MIN function can be used when you want to get the smallest value from a set of values. RANK Function Excel RANK function can be used when you want to rank a number against a list of numbers. COUNT Function Excel COUNT function can be used to count the number of cells that contain numbers. LARGE Function Excel 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 Function Returns the Kth LARGEST value from a list of supplied numbers, for a given value K SMALL Function Excel SMALL function can be used to get the Kth smallest value from a range of cells or array. COUNTA Function Excel COUNTA function can be used when you want to count all the cells in a range that are not empty. MEDIAN Function Returns the Median (the middle value) of a list of supplied numbers AVERAGE Function Excel AVERAGE function can be used when you want to get the average (arithmetic mean) of the specified arguments. COUNTIF Function Excel COUNTIF function can be used when you want to count the number of cells that meet specified criteria. COUNTIFS Function Excel COUNTIFS function can be used when you want to count the number of cells that meet a single or multiple criteria. AVERAGEIF Function Excel 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 Function Returns an array showing the number of values from a supplied array, which fall into specified ranges AVERAGEIFS Function Excel 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 Function Excel COUNTBALNK function can be used when you have to count all the empty cells in a range.

## Information Functions

 Functions Description ISNA Function Excel ISNA function returns TRUE when specified condition is TRUE. For example, ISNA would return TRUE if the cell has a #N/A! error. ISTEXT Function ISTEXT function checks whether supplied cell value is text, it returns TRUE or FALSE ISBLANK Function ISBLANK function is use to check whether cell reference is to empty, and returns TRUE or FALSE ISERROR Function ISERROR function we use to check that supplied cell reference is having error or not. Function returns TRUE or FALSE ISNUMBER Function ISNUMBER function checks whether supplied cell value is number , it returns TRUE or FALSE ISLOGICAL Function ISLOGICAL function can be used to check for the logical value for the supplied cell reference