Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel for Mac
It’s a list of Top 100 Excel Functions with examples and sample files.
Text Functions
| Name | Description |
|---|---|
| Excel FIND Function | Returns the starting position of a text string in another text string (case sensitive). |
| Excel LEFT Function | Returns the string from another string starting from the left. |
| Excel LEN Function | Counts the number of characters from the value supplied. |
| Excel LOWER Function | Convert a text into lower case. |
| Excel MID Function | Returns a substring from a string using a specific position and number of characters. |
| Excel PROPER Function | Convert a text to a proper case text. |
| Excel REPT Function | Repeats a value several times. |
| Excel RIGHT Function | Returns the string from another string starting from the right. |
| Excel SEARCH Function | Returns the starting position of a text string in another text string (case sensitive). |
| Excel UPPER Function | Convert a text into an upper case text. |
Date Functions
| Name | Description |
|---|---|
| Excel DATE Function | Returns a valid date using the day, month, and year supplied. |
| Excel DATEDIF Function | Calculates the difference between two dates. |
| Excel DATEVALUE Function | Converts a date that is formatted as text into an actual date. |
| Excel DAY Function | Returns the day from the date supplied. |
| Excel DAYS Function | Returns the count of days between two dates. |
| Excel EDATE Function | Returns a date after adding/subtracting months from the supplied date. |
| Excel EOMONTH Function | Returns the end of the month date from a future month or a past month. |
| Excel MONTH Function | Returns the month from the date supplied. |
| Excel NETWORKDAYS Function | Count of days between the start date and end date, excluding weekends and holidays. |
| Excel NETWORKDAYS.INTL Function | Count of days between the start date and end date, excluding weekends (Custom), and holidays. |
| Excel TODAY Function | Returns the current date. |
| Excel WEEKDAY Function | Returns the day number (ranging from 1 to 7) of the date in the week. |
| Excel WEEKNUM Function | Returns the week number (in the whole year) of the date ranging from 1 to 54. |
| Excel YEAR Function | Returns the year from the date supplied. |
Time Functions
| Name | Description |
|---|---|
| Excel HOUR Function | Returns the hours from the time supplied. |
| Excel MINUTE Function | Returns the minutes from the time supplied. |
| Excel NOW Function | Returns the current date and time. |
| Excel SECOND Function | Returns the seconds from the time supplied. |
| Excel TIME Function | Returns a valid time using the hours, minutes, and seconds supplied. |
| Excel TIMEVALUE Function | Convert a time value that is stored as text into actual time. |
Logical Functions
| Name | Description |
|---|---|
| Excel AND Function | Test multiple conditions and return TRUE if all the conditions are TRUE. |
| Excel FALSE Function | Returns the boolean value FALSE. |
| Excel IF Function | Tests a condition and returns a value if that condition is TRUE else some other value. |
| Excel IFERROR Function | Tests a value for an error and returns the specified value if an error occurred, else returns the original value. |
| Excel IFNA Function | Tests a value for #N/A error and returns the specified value if the error occurred, else returns the original value. |
| Excel NOT Function | Reverse a logical result/value. |
| Excel OR Function | Test multiple conditions and return TRUE if any of the conditions are TRUE. |
| Excel TRUE Function | Returns the boolean value TRUE. |
Math Functions
| Name | Description |
|---|---|
| Excel ABS Function | Converts a number into an absolute number. |
| Excel EVEN Function | Rounds a number to the nearest even number. |
| Excel INT Function | Returns the integer part from the value supplied. |
| Excel MOD Function | Returns the remainder value after dividing a number with a divisor. |
| Excel MROUND Function | Rounds a number to a given multiple. |
| Excel RAND Function | Returns a random number ranging from 0 to 1. |
| Excel SUM Function | Sum the value supplied. |
| Excel SUMIF Function | Sum the value supplied using the condition specified. |
| Excel SUMIFS Function | Sum the value supplied using the multiple conditions specified. |
| Excel SUMPRODUCT Function | Multiply and sum the array values. |
| Excel TRUNC Function | Returns a number after truncating the original number. |
Statistical Functions
| Name | Description |
|---|---|
| Excel AVERAGE Function | Calculates the average of the supplied numeric values. |
| Excel AVERAGEA Function | Calculates the average of the supplied numeric values, boolean, and numbers formated as text. |
| Excel AVERAGEIF Function | Calculates the average of the numbers based on the conditions you specify. |
| Excel AVERAGEIFS Function | Calculates the average of the numbers based on the multiple conditions you specify. |
| Excel COUNT Function | Counts the supplied numeric values. |
| Excel COUNTA Function | Counts the supplied values except for blanks. |
| Excel COUNTBLANK Function | Counts the blank values. |
| Excel COUNTIF Function | Counts the values supplied using the condition specified. |
| Excel COUNTIFS Function | Counts the values supplied using the multiple conditions specified. |
| Excel MAX Function | Returns the maximum value from a list of values. |
| Excel MIN Function | Returns the minimum value from a list of values. |
Lookup Functions
| Name | Description |
|---|---|
| Excel ADDRESS Function | Creates a valid cell reference as per the supplied row and column. |
| Excel AREAS Function | Counts the number of ranges in the supplied reference. |
| Excel CHOOSE Function | Returns a value from a list of values using the index number. |
| Excel COLUMN Function | Returns the column number of the referred cell. |
| Excel COLUMNS Function | Count columns referred to in the supplied range. |
| Excel FORMULATEXT Function | Returns the formulas from the cell referred to. |
| Excel HLOOKUP Function | Lookups for a value in the top row of a table and returns the value from the same column using an index number. |
| Excel HYPERLINK Function | Create a text with the hyperlink using the link specified. |
| Excel INDEX Function | Returns a value from a list using the index number of that value in the list. |
| Excel INDIRECT Function | Create a valid cell reference from the text supplied. |
| Excel LOOKUP Function | Lookup for a valuer from a row, column, or an array. |
| Excel MATCH Function | Returns the index number of the value from the list of values. |
| Excel OFFSET Function | Returns a reference to a range which is a specific number of rows and columns away from a cell or range of cells. |
| Excel ROW Function | Returns the row number of the referred cell. |
| Excel ROWS Function | Count rows referred to in the supplied range. |
| Excel TRANSPOSE Function | Changes the orientation of a range. |
| Excel VLOOKUP Function | Lookups for a value in the first column of a table and returns the value from the same row of the matched value using the index number. |
Information Functions
| Name | Description |
|---|---|
| Excel CELL Function | Returns specific information about the cell referred to. |
| Excel ERROR.TYPE Function | Returns a number that represents the error. |
| Excel INFO Function | Returns information about the current operating environment. |
| Excel ISBLANK Function | Checks if the supplied value is blank and returns TRUE. |
| Excel ISERR Function | Checks if the supplied value is an error other than #N/A and returns TRUE. |
| Excel ISERROR Function | Checks if the supplied value is an error and returns TRUE. |
| Excel ISEVEN Function | Checks if the supplied value is an even number and returns TRUE. |
| Excel ISFORMULA Function | Checks if the supplied value is a formula and returns TRUE. |
| Excel ISLOGICAL Function | Checks if the supplied value is logical value and returns TRUE. |
| Excel ISNA Function | Checks if the supplied value is an #N/A and returns TRUE. |
| Excel ISNONTEXT Function | Checks if the supplied value is a non-text value and returns TRUE. |
| Excel ISNUMBER Function | Checks if the supplied value is number and returns TRUE. |
| Excel ISODD Function | Checks if the supplied value is an odd number and returns TRUE. |
| Excel ISREF Function | Checks if the supplied value is a reference and returns TRUE. |
| Excel ISTEXT Function | Checks if the supplied value is a text and returns TRUE. |
| Excel N Function | Converts a boolean to a number. |
| Excel NA Function | Returns the #N/A. |
| Excel SHEET Function | Returns the sheet number of the referred cell. |
| Excel SHEETS Function | Counts the number of sheets in the reference. |
| Excel TYPE Function | Checks a value for an error and returns a number to represent it. |
Financial Functions
| Name | Description |
|---|---|
| Excel FV Function | Calculates the future value of an investment. |
| Excel PMT Function | Calculate a periodic payment of loan which you need to pay. |
| Excel PV Function | Calculates the present value of financial investment or a loan. |
Learn More
Thank you very much
Thank you sir I must so help ful.
=search(“9″,”99 9000”) = result is 1
How about another “9” position? What is formula?
Sir, 2nd Sept.2019.
Really you have shown very clearly and deeply all points.
I must thank you.
Hoping to receive more articles in future too.
Kanhaiyalal Newaskar.
Thank you for your generosity.
NICE, REALLY HELPFUL
Thank u
Thank you for working hard to help others. Your generous effort will be put into good use.
Thank you for your hard work for helping out us…
Use RANK function
This is amazing and very generous of you…many thanks…
You’re Welcome 🙂
This is very useful, but I often don’t have access to the internet when I am working in Excel. Could you make this information in a PDF file, so that it would be accessible offline?
Lavoro ottimo e ++ utile. Grazie e complimenti
nice information
we are here because you and your work is awesome. 😉
Keep on sharing. This help us a lot. Its a time save for us and no need to search each functions from net cause its already here.
Hi, I find your Excel tips very useful. It helps me a lot. Tips likes this give me a lesser time to search for the uses and functions of each formulas. Thanks a lot.
Very useful information..thank you sir
Sir, very useful information,notes and formula you have given.User like me would appreciate the work.
Once again thanks.
Thank you very much Mr. Punit Sir. I am computer faculty and recently I have asked to teach Excel functions and I find the complete list here. Could you possibly provide us the PDF format of all the functions with examples to use. Thank you.
Thanks a lot for sharing your knowledge with us with clear explanation. Your blog is my guru. All your excel tips are being very useful for my work. Thanks again.
GDay Punit
Needed a refresher, thanks for the info.
First of All.. Thank you for sharing the above info.. I fully appreciate this gesture..
A honest effort with intention of educating…. Really Super …………..
Hello Punit,
I am very thankful to you as you have start this learning portal for all. And thanks for giving ur stuff from this web portal i will be able to use excel smartly and efficiently. I learn so far with this really Excellent work ur doing
Thanks a lot again.
Thank you 🙂
Dear Puneet thanks, i want learn Macro in detail, can you help me
Thanks
Nitin
Please check each category. some files are not there or linked wrong
Dear Puneet,
Excellent work. Many files are not working or the link is wrong.
Thanks Rashid