In Excel, a function is a predefined formula that performs a specific calculation or task. Functions are built-in tools that allow you to automate calculations and manipulate data in various ways. They can be used to perform simple calculations like addition or subtraction, as well as more complex operations such as statistical analysis, financial calculations, and text manipulation.

Excel provides a wide range of functions to handle different types of data and perform various operations. Some common functions in Excel include SUM, AVERAGE, MAX, MIN, COUNT, IF, VLOOKUP, and CONCATENATE, among many others. Each function has a specific syntax (the way it is written) and requires specific arguments (input values) to perform the desired calculation.

By using functions in Excel, you can save time and effort by letting the software handle repetitive or complex calculations automatically. Functions can be entered directly into cells or used within formulas to perform calculations based on the values in other cells. They allow you to perform powerful data analysis and manipulate your data in meaningful ways.

For example, you have a dataset like the following. There are some clothing products in column A, and their corresponding prices & units are listed in the next two columns (B & C). Letâ€™s say you want to know the total sales for all products. Youâ€™ll have to multiply a productâ€™s price by its unit and then sum up the prices for all products, right?

But if you want to perform this manual calculation, itâ€™ll take some time and it matters most when you have to deal with a large amount of data. The SUMPRODUCT function in Excel will do this job for you in seconds. No matter how large the dataset is, the built-in function in Excel will save you crucial amounts of time. Letâ€™s have a look at how you can apply the SUMPRODUCT function to get the total sales for our given dataset in the screenshot below.

Here, the SUMPRODUCT function in cell B9 has taken 2 arguments- 1st one is the cell references (B2:B7) of the Price column & the 2nd one has come from the cell range (C2:C7) under the Unit header. And the output is just as what we expected- the total sales value, which weâ€™ve found in seconds! And this is what a built-in function is able to do for you by saving thousands of seconds or minutes from your regular work.

**Table of Contents**Expand

## 190++ Most Important & Useful Excel Functions by Category

There are around 450+ built-in functions in Microsoft Excel. Among them, weâ€™ll cover the most common & crucial functions that we have to use in our spreadsheets regularly. For your convenience, weâ€™ve categorized the list of all functions and linked them with individual articles. When you click on a function name, itâ€™ll open a new tab in your browser & redirect you to the particular function page. Youâ€™ll get all the necessary information & uses of that particular function in the article.

### 70 Most Popular & Common Excel Functions by Alphabetical Order

Before you dip into the main categories, you can have a glance at our selected list of the most common & popular Excel functions. Excel users around the world want to know about the basics of these functions in web searches and so we have added all those functions to a primary list. By learning the basics of all these functions, you can claim yourself an intermediate Excel user who is able to apply the necessary functions and combine them to build a useful formula for different purposes in the spreadsheets.

Function Name | Objective |
---|---|

AND |
Checks whether all the arguments are TRUE, and returns TRUE if all arguments are TRUE. |

AVERAGE |
Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers. |

AVERAGEIF |
Finds average for the cells specified by a given condition or criterion. |

AVERAGEIFS |
Returns the average of the cells of an array that satisfy one or more given criteria. |

CHOOSE |
Chooses a value or action to perform from a list of values, based on an index number. |

COLUMN |
Returns the column number of a cell reference. |

COLUMNS |
Checks the number of columns in an array or reference and returns the number in digits. |

CONCATENATE |
Joins two or more text values or numbers into one single text value. |

CORREL |
Calculates the correlation coefficient of two cell ranges. |

COUNT |
Counts the number of cells in a range that contains numbers. |

COUNTA |
Counts the number of cells in a range that is not empty. |

COUNTIF |
Counts the number of cells within a range that meets the given condition. |

DATE |
Creates a date from numeric values in the arguments. |

DATEDIF |
Determines how many days, months, or years there are between two dates. |

DAY |
Returns the day of a date as a number between 1 and 31. |

FILTER |
Filters some particular cells or values according to our requirements. |

FIND |
Returns the starting position of a case-sensitive text string within another text string. |

FLOOR |
Rounds a number down to the nearest multiple of significance. |

FORECAST |
Predicts or calculates a future value with a linear trend. |

FREQUENCY |
Returns how often numeric values occurred within the ranges you specify in a bin table of a set of data or dataset. |

HLOOKUP |
Searches for a value in the top row of a table or array of values and returns the value in the same column from the specified row. |

IF |
Checks whether a condition is met, and returns one value if TRUE, and another one if FALSE. |

IFS |
Takes multiple conditions and values and returns the corresponding value to the first TRUE. |

INDIRECT |
Stores data from the reference specified by a text string. |

INT |
Rounds a decimal number down to the lowest integer portion. |

IRR |
Calculates the internal rate of return. |

ISNA |
Checks whether a value is #N/A, and returns TRUE or FALSE. |

LARGE |
Returns the K-th largest value in a dataset where K must be a positive integer. |

LEFT |
Finds the several characters of a text from left according to the number you provide. |

LEN |
Reflects the length of text as a number. |

LINEST |
Finds the least-squares method to compute the statistics for a straight line and returns an array describing that line. |

LOOKUP |
Looks up a value in the one-row or one-column range. |

MATCH |
Returns the lookup valueâ€™s relative position. |

MAX |
Returns the largest value in a set of values. Ignores logical values and text. |

MID |
Returns a specific number of characters from the middle of a string, given a specific starting position. |

MIN |
Extracts the lowest or smallest value from a range of cells or cell references. |

MOD |
Returns the remainder after a number is divided by a divisor. |

MODE |
Returns the most frequently occurring, or repetitive, value in an array or a range of data. |

NOT |
Always returns a logically opposite value. |

OFFSET |
Starts off from a particular cell reference, moves to a specific number of rows down, then to a specific number of columns right, and then extracts out a section from the data set having a specific height and width. |

OR |
Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE. |

PMT |
Calculates the payment for a loan based on a constant interest rate. |

POWER |
Returns a number raised to a power. |

PRODUCT |
Calculates the multiplication among numbers in Excel. |

PROPER |
Converts a text string into the proper case; the first letter in each word to uppercase, and all other letters to lowercase. |

PV |
Calculates the present value of a loan or investment. |

RANK |
Returns the position of a given number in a given list of other numbers. |

RATE |
Calculates the rate of interest. |

REPLACE |
Replaces a part of a text string with a different text string. |

REPT |
Repeats text a given number of times. |

RIGHT |
Extract a specified number of characters from a given string from right to left. |

ROUND |
Rounds a number based on the provided number of digits. |

ROUNDUP |
Rounds a number up, away from zero. |

ROW |
Returns the row number for a given cell reference. |

SEARCH |
Returns the number of characters after finding a specific character or text string, reading from left to right. |

SMALL |
Finds the k-th (generally what we know as nth) smallest value in a data set. |

SORT |
Sorts a given range of cells according to a specific row or column in ascending or descending order. |

SUM |
Adds all the numbers in each range of cells. |

SUMIF |
Adds the cells specified by a given condition or criteria. |

SUMIFS |
Add the cells given by specified conditions or criteria. |

SUMPRODUCT |
Takes one or more arrays as an argument, multiplies the corresponding values of all the arrays, and then returns the sum of the products. |

TEXT |
Converts a value to text in a specific number format. |

TODAY |
Returns the current date formatted as a date. |

TRANSPOSE |
Converts a vertical range of cells to a horizontal range or vice versa. |

TREND |
Calculates the values of a given set of X and Y and returns additional Y-values by using the least square method based on a new set of X-values along with a linear trend line. |

TRIM |
Removes extra spaces from a text string. |

UNIQUE |
Returns a list of unique values in a range or in a list. |

VALUE |
Converts a text string that represents a number to a number. |

VLOOKUP |
Looks for a given value in the leftmost column of a given table and then returns a value in the same row from a specified column. |

WEEKDAY |
Returns the day of the week for a given argument. |

### Excel Database Functions

In Excel, database functions are a set of specialized functions that enable you to perform calculations and analysis on data stored in a database format. These functions are designed to work specifically with lists or tables of data that are structured in a consistent manner.

The database functions in Excel are useful when you need to extract or summarize data based on specific criteria, calculate statistics, or perform calculations on filtered data within a database. They can be used to perform tasks such as counting, summing, averaging, finding the maximum or minimum values, and more.

For example, we have a dataset like below. We need to know the minimum total price for laptop from the given data table. So, we can use **the DMIN function** with appropriate arguments to extract the minimum total price for a laptop easily.

Function Name | Objective |
---|---|

DCOUNT |
Counts the cells that contain numbers in a field (column) of records in a list or database that fit the requirements that we define. |

DCOUNTA |
Enumerates the number of non-empty cells in a given database based on criteria. |

DMIN |
Determines the minimum value for a field/column based on user-specified criteria. |

DPRODUCT |
Returns the product of a defined field from a database that matches specified criteria. |

DSTDEV |
Calculates the standard deviation of a population based on a sample of data. |

DSTDEVP |
Determines the standard deviation of a population based on the entire population by using the number or name of the heading in a column of the dataset that matches the conditions that are mentioned. |

DSUM |
Calculates the total sum of a specific Field by matching specific Criteria from a given Range. |

DVAR |
Obtains sample variance for matching records. |

### Excel Date & Time Functions

The date and time functions allow you to work with dates and times in various ways. These functions enable you to perform calculations, and format date & time values within your spreadsheets. They are useful for tasks such as calculating durations, extracting specific components from dates or times, formatting date and time values, and more.

For example, we can use **the NETWORKDAYS function** to extract the total number of days between two given dates considering all listed holidays & weekends.

Function Name | Objective |
---|---|

DATE |
Create a date from numeric values in the arguments. |

DATEDIF |
Returns the difference of days, months or years between two dates. |

DATEVALUE |
Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code. |

DAY |
Returns the day of a date as a number between 1 and 31. This function is used for extracting a day number from a date. |

DAYS |
Returns the number of days between two dates. |

EDATE |
Provides a date according to the month number given in the argument. |

EOMONTH |
Returns a string of numbers that represent the last day of the month before or after a specified number of months. |

HOUR |
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). |

MINUTE |
Returns the number of minutes in a given time value. |

MONTH |
Gets the month, as a number from 1 (January) to 12 (December). |

NETWORKDAYS |
Returns the number of whole workdays between two dates. |

NETWORKDAYS.INTL |
Returns the number of whole workdays between 2 dates with custom weekend parameters. |

NOW |
Returns with the current date and time formatted as a date and time. |

SECOND |
Extracts seconds from different types of time input. |

TIME |
Returns the decimal number for an individual time. |

TIMEVALUE |
Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). |

TODAY |
Returns the current date formatted as a date. |

WEEKDAY |
Returns a number from 1 to 7 identifying the day of the week to a given date. |

WEEKNUM |
Calculates the week number of a date. |

WORKDAY |
Returns a date that is n working days in the future or the past. |

WORKDAY.INTL |
Returns the serial number of the date before or after a specified number of weekdays with custom weekend parameters. |

YEAR |
Calculates a year number from a date and it returns a 4-digit year of the corresponding date. |

YEARFRAC |
Calculates the fraction of the year represented by the number of whole days between two dates. |

### Excel Engineering Functions

The engineering functions simply perform engineering and scientific calculations, such as converting units, formatting binary values, working with complex numbers, and more. These functions can be used to solve specific engineering problems, perform conversions between different number systems, and handle complex calculations that are common in scientific and technical fields.

For example, we can use **the CONVERT function** for unit conversion as shown in the screenshot below.

Function Name | Objective |
---|---|

COMPLEX |
Combines real and imaginary components together into complex values. |

CONVERT |
Converts a number from one measurement system to another. |

IMDIV |
Returns the result after dividing a complex number by another complex number. |

IMAGINARY |
Extracts the imaginary coefficient from the corresponding complex number in Excel. |

IMPRODUCT |
Returns the product of complex numbers, up to a maximum of 255 numbers. |

IMSUM |
Returns the sum of two or multiple complex numbers in Excel. |

### Excel Financial Functions

In Excel, financial functions are a set of built-in functions that ease your tasks with financial calculations and analysis. These functions are specifically designed for tasks related to finance, investments, loans, and other financial operations. They allow you to perform various calculations, such as determining loan payments, calculating interest, analyzing investment returns, and more. They are particularly useful for financial professionals, investors, and anyone involved in financial planning, analysis, or decision-making.

**PV function** is one of the most commonly used financial functions in Excel which we can use to determine the present value of a loan or investment under the given criteria.

Function Name | Objective |
---|---|

DB |
Determines the depreciation cost of an asset in each period of time over its lifetime. |

EFFECT |
Returns an effective annual interest rate based on the nominal interest rate and the number of compounding periods per year. |

FV |
Calculates the future value of an investment. |

IPMT |
Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate. |

IRR |
Calculates the internal rate of return. |

MIRR |
Considers both the finance and reinvest rates to calculate the modified internal rate of return. |

NOMINAL |
Returns the nominal annual interest rate. |

NPER |
Calculates the total number of periods over which the loan is fixed with a constant interest rate. |

NPV |
Calculates the net present value (NPV) of an investment using a discount rate and a series of future cash flows. |

PDURATION |
Calculates the number of periods required for an investment to reach a designated future value, at a constant interest rate. |

PMT |
Returns the loan payments as a number. |

PPMT |
Returns principal payments for a given period. |

PRICE |
Calculates the breakeven price per $100 face value of a bond or security. |

PV |
Calculates the present value of a loan or investment. |

RATE |
Calculates the rate of interest. |

RRI |
Returns us an equivalent interest rate for the growth of an investment over a certain period. |

SLN |
Returns the straight-line depreciation of an asset for one period. |

XIRR |
Calculates the internal rate of return (IRR) for a series of cash flows. |

YIELD |
Calculates the yield that pays interest on purchased bonds or security on a regular basis. |

### Excel Information Functions

The information functions allow you to extract specific details about the data within cells and make decisions or perform calculations based on that information. These functions are useful for conditional formatting, data validation, or creating formulas that depend on specific cell characteristics.

For example, we can use **the ISBLANK function** to find the blank cells and later based on the outputs, we can show the conditional return values by combining it with another function.

Function Name | Objective |
---|---|

CELL |
Returns information about a cell color, file name, contents, format, row, etc. |

ISBLANK |
Evaluates if the cell is blank. |

ISERROR |
Indicates any error value. |

ISEVEN |
Determines if a number is even. |

ISLOGICAL |
Checks if a cell contains any boolean or logical values. |

ISNA |
Checks whether a value is #N/A, and returns TRUE or FALSE. |

ISNUMBER |
Check whether a value is a number or not. |

ISODD |
Determines if a number is odd. |

ISTEXT |
Checks whether a value is text or not. |

N |
Returns a value converted to a number. |

SHEETS |
Counts the number of sheets. |

TYPE |
Returns an integer number that represents the type of the selected data. |

### Excel Logical Functions

In Excel, logical functions evaluate logical conditions and return true or false results. These functions are used to perform logical comparisons, make decisions, and test conditions within formulas or logical statements.

In the following example, we can find the use of the IF function. Here, based on the deadline of the payment, we can combine **IF** and **DATE** functions to know the payment status of the students.

Function Name | Objective |
---|---|

AND |
Checks whether all the arguments are TRUE, and returns TRUE if all arguments are TRUE. |

FALSE |
Returns the word FALSE to make remarks or compare with others. |

IF |
Checks whether a condition is met, and returns one value if TRUE, and another one if FALSE. |

IFERROR |
Generates a custom value as a result if there is any error from the formula. |

IFNA |
Tackles the #N/A error. |

IFS |
Takes multiple conditions and values and returns the corresponding value to the first TRUE. |

NOT |
Returns a logically opposite value. |

OR |
Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE. |

SWITCH |
Compares or evaluates a given expression which is a value against a list of values and returns a result corresponding to the first match found. |

TRUE |
Returns the logical value TRUE based on a condition. |

XOR |
Performs an exclusive OR function. |

### Excel Lookup & Reference Functions

The reference and lookup functions are used to extract data from specific cells, ranges, or tables based on certain criteria or conditions. These functions allow you to search for values, match data across multiple ranges, and extract information from different parts of your spreadsheet.

For example, if we have a glance at the picture below, **the HLOOKUP function** here can be used to find the sales of a particular food item for a given date.

Function Name | Objective |
---|---|

ADDRESS |
Creates a cell reference as text, given specified row and column numbers. |

CHOOSE |
Chooses a value or action to perform from a list of values, based on an index number. |

COLUMN |
Returns the column number of a cell reference. |

COLUMNS |
Returns the count of columns in a given reference. |

FILTER |
Filter some particular cells or values according to our requirements. |

FORMULATEXT |
Returns the used formula as a string. |

HLOOKUP |
Searches for a value in the top row of a table or array of values and returns the value in the same column from the specified row. |

HYPERLINK |
Brings out a cutoff link that will open on a server, or make a move to other worksheets. |

INDEX |
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range. |

INDIRECT |
Stores data from the reference specified by a text string. |

LOOKUP |
Looks up a value in the one-row or one-column range. |

MATCH |
Returns the lookup valueâ€™s relative position. |

OFFSET |
Starts off from a particular cell reference, moves to a specific number of rows down, then to a specific number of columns right, and then extracts out a section from the data set having a specific height and width. |

ROW |
Returns the row number for a given reference. |

ROWS |
Returns the number of rows in a reference or array. |

SORT |
Sorts a given range of cells according to a specific row or column in ascending or descending order. |

TRANSPOSE |
Converts a vertical range of cells to a horizontal range or vice versa. |

UNIQUE |
Returns a list or array of unique values. |

VLOOKUP |
Looks for a given value in the leftmost column of a given table and then returns a value in the same row from a specified column. |

XLOOKUP |
Searches a range or an array for a match and returns the corresponding item from a second range or array. |

### Excel Math & Trig Functions

In Excel, the math and trig functions are a set of built-in functions that perform various mathematical and trigonometric calculations. These functions allow you to perform calculations involving numbers, angles, and geometric operations.

These math and trig functions enable you to perform a wide range of mathematical calculations, such as basic arithmetic operations, statistical analysis, rounding, exponentiation, and trigonometric calculations.

For example,** the MOD function** in Excel can be used to determine the remainder of a division between two valid numbers.

Function Name | Objective |
---|---|

ABS |
Returns the absolute value of a number. |

AGGREGATE |
Is used on different functions like AVERAGE, COUNT, MAX, MIN, SUM, PRODUCT, etc., with the option to ignore hidden rows and error values to get certain results. |

CEILING |
Rounds up a number to its nearest upper integer or to the multiple of significance. |

COMBIN |
Determines the total possible number of combinations for a given number of items without any repetition in Excel. |

COS |
Determines the cosine of angles in Excel. |

EVEN |
Rounds any number to a nearly even integer number. |

EXP |
Calculates and returns the value of the constant e raised to the power of a given number. |

FACT |
Returns the factorial of a number. |

FLOOR |
Rounds a number down to the nearest multiple of significance. |

INT |
Rounds a decimal value down to the lowest integer portion. |

LN |
Calculates the natural logarithm of a number. |

LOG |
Returns the logarithm of a number to the base you specify. |

MMULT |
Multiplies two arrays of numbers and returns another array of numbers. |

MOD |
Returns the remainder after a number is divided by a divisor. |

ODD |
Rounds up or down a number to the nearest odd integer. |

PI |
Returns the value of Pi, 3.14159265358979, accurate to 15 digits. |

POWER |
Returns a number raised to a power. |

PRODUCT |
Calculates the multiplication among numbers in Excel. |

QUOTIENT |
Returns the integer part of a division without remainder. |

RAND |
Returns a random number between 0 and 1. |

RANDBETWEEN |
Returns a random integer between two given numbers, called bottom and top. |

ROUND |
Rounds a number based on the provided number of digits. |

ROUNDDOWN |
Rounds a number down, toward zero. |

ROUNDUP |
Rounds a number up, away from zero. |

SEQUENCE |
Creates a sequence of numeric values. |

SIGN |
Returns a numberâ€™s sign as 0, +1, or -1. |

SIN |
Determines the sine of angles in Excel. |

SQRT |
Returns the square root of a number. |

SUBTOTAL |
Offers 11 maths & trig functions to perform by inserting the corresponding argument. |

SUM |
Adds all the numbers in each range of cells. |

SUMIF |
Adds the cells specified by a given condition or criteria. |

SUMIFS |
Adds the cells given by specified conditions or criteria. |

SUMPRODUCT |
Takes one or more arrays as an argument, multiplies the corresponding values of all the arrays, and then returns the sum of the products. |

TAN |
Determines the tangent of an angle. |

TRUNC |
Truncates a number to an integer by removing the decimal, or fractional, part of the number. |

### Excel Statistical Functions

The statistical functions allow you to perform statistical analysis and calculations on data sets. These functions enable you to calculate various statistical measures, such as averages, standard deviations, correlations, and more.

**The AVERAGEIF function** is one of the most used statistical functions in Excel which can be used to find an output based on given conditions.

Function Name | Objective |
---|---|

AVERAGE |
Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers. |

AVERAGEA |
Calculates the average of a group of values â€“ numbers, texts or boolean â€“ and returns the average (arithmetic mean) of the values. |

AVERAGEIF |
Finds average for the cells specified by a given condition or criteria. |

AVERAGEIFS |
Returns the average of the cells of an array that satisfy one or more given criteria. |

CORREL |
Calculates the correlation coefficient of two cell ranges. |

COUNT |
Counts the number of cells in a range that contains numbers. |

COUNTA |
Counts the number of cells in a range that is not empty. |

COUNTBLANK |
Counts the number of empty cells in a specified range of cells. |

COUNTIF |
Counts the number of cells within a range that meets the given condition. |

COUNTIFS |
Counts the number of cells in one or more given arrays that maintain one or more specific criteria. |

FORECAST |
Calculates or predicts a future value based on existing value. |

FREQUENCY |
Returns how often numeric values occurred within the ranges you specify in a bin table of a set of data or dataset. |

GAMMA |
Finds the gamma function value of a number. |

GROWTH |
Calculates predictive exponential growth for a given set of data. |

INTERCEPT |
Determines the location where a regression line will intersect the y-axis. |

LARGE |
Returns the K-th largest value in a dataset where K must be a positive integer. |

LINEST |
Finds the least-squares method to compute the statistics for a straight line and returns an array describing that line. |

MAX |
Returns the largest value in a given list of arguments. |

MEDIAN |
Returns the median of a group of numbers. |

MIN |
Extracts the lowest or smallest value from a range of cells or cell references. |

MODE |
Returns the most frequently occurring, or repetitive, value in an array or a range of data. |

PERCENTILE |
Calculates the kth percentile of the values in a particular data range. |

PERMUT |
Returns the number of permutations for a chosen number of objects from a total number of objects without repetitions. |

QUARTILE |
Finds the quartile (each of four equal groups) for a conveyed set of data. |

RANK |
Returns the position of a given number in a given list of other numbers. |

SKEW |
Calculates the skewness of a range of data in Excel. |

SLOPE |
Returns the slope of the linear regression line through known yâ€™s and known xâ€™s data points. |

SMALL |
Finds the k-th (generally what we know as nth) smallest value in a data set. |

STDEV |
Estimates standard deviation. |

VAR |
Returns the variance of a sample taken from population data. |

### Excel Text Functions

In Excel, the text functions are a group of built-in functions that allow you to format text strings in various ways. These functions enable you to extract specific parts of a text, combine or concatenate multiple text strings, change the case of text, convert numbers to text, and more.

These text functions provide flexibility in working with text data in Excel. They can be used to clean data, extract information, create customized labels, and generate reports.

For example, we can combine **FIND** and **MID** functions to extract text or a word from the beginning of a cell.

Function Name | Objective |
---|---|

CHAR |
Returns the character specified by the code number from the character set for your computer. |

CLEAN |
Removes all of the non-printable characters from text. |

CODE |
Returns a numeric code for the first character in a text string, in the character set used by your computer. |

CONCATENATE |
Joins two or more text values or numbers into one single text value. |

DOLLAR |
Converts a number into text in the form of a currency. |

EXACT |
Compares two texts and then returns TRUE (in case the texts are exactly the same) or FALSE (in case the texts are exactly not the same). |

FIND |
Returns the starting position of a case-sensitive text string within another text string. |

FIXED |
Rounds a number to the fixed number of decimals, and formats the number in decimal format using a period and commas. |

LEFT |
Returns a specified number of characters from the start of the provided text string. |

LEN |
Returns the length of a given string. |

LOWER |
Converts all the letters in a text string to lowercase. |

MID |
Returns a specific number of characters from the middle of a string, given a specific starting position. |

PROPER |
Capitalizes the first letter of each word in a given text string. |

REPLACE |
Replaces a part of a text string with a different text string. |

REPT |
Repeats text a given number of times. |

RIGHT |
Extracts a specified number of characters from a given string from right to left. |

SEARCH |
Returns the number of characters after finding a specific character or text string, reading from left to right. |

SUBSTITUTE |
Replaces existing text with new text in a text string. |

TEXT |
Converts a value to text in a specific number format. |

TEXTJOIN |
Concatenates a list or range of text strings into a single string using a delimiter. |

TRIM |
Removes the extra spaces from a text string. |

UPPER |
Converts a text string to all uppercase letters. |

VALUE |
Converts a text string that represents a number to a number. |

## Concluding Words

In this article, we have covered 190+ functions with redirected posts. You can also have a look at our **102 Excel Cheatsheet Formulas** where the functions have been explained elaborately. You can download the free pdf version of the functions cheatsheet too there.

## Excel Functions: Knowledge Hub

**<< Go Back to ****Learn Excel**