Excel Functions List (Top 100) Examples + Sample File

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.
[sc name=”ad-level-2″ ]

Date Functions

NameDescription
Excel DATE FunctionReturns a valid date using the day, month, and year supplied.
Excel DATEDIF FunctionCalculates the difference between two dates.
Excel DATEVALUE FunctionConverts a date that is formatted as text into an actual date.
Excel DAY FunctionReturns the day from the date supplied.
Excel DAYS FunctionReturns the count of days between two dates.
Excel EDATE FunctionReturns a date after adding/subtracting months from the supplied date.
Excel EOMONTH FunctionReturns the end of the month date from a future month or a past month.
Excel MONTH FunctionReturns the month from the date supplied.
Excel NETWORKDAYS FunctionCount of days between the start date and end date, excluding weekends and holidays.
Excel NETWORKDAYS.INTL FunctionCount of days between the start date and end date, excluding weekends (Custom), and holidays.
Excel TODAY FunctionReturns the current date.
Excel WEEKDAY FunctionReturns the day number (ranging from 1 to 7) of the date in the week.
Excel WEEKNUM FunctionReturns the week number (in the whole year) of the date ranging from 1 to 54.
Excel YEAR FunctionReturns the year from the date supplied.

Time Functions

NameDescription
Excel HOUR FunctionReturns the hours from the time supplied.
Excel MINUTE FunctionReturns the minutes from the time supplied.
Excel NOW FunctionReturns the current date and time.
Excel SECOND FunctionReturns the seconds from the time supplied.
Excel TIME FunctionReturns a valid time using the hours, minutes, and seconds supplied.
Excel TIMEVALUE FunctionConvert a time value that is stored as text into actual time.

Logical Functions

NameDescription
Excel AND FunctionTest multiple conditions and return TRUE if all the conditions are TRUE.
Excel FALSE FunctionReturns the boolean value FALSE.
Excel IF FunctionTests a condition and returns a value if that condition is TRUE else some other value.
Excel IFERROR FunctionTests a value for an error and returns the specified value if an error occurred, else returns the original value.
Excel IFNA FunctionTests a value for #N/A error and returns the specified value if the error occurred, else returns the original value.
Excel NOT FunctionReverse a logical result/value.
Excel OR FunctionTest multiple conditions and return TRUE if any of the conditions are TRUE.
Excel TRUE FunctionReturns the boolean value TRUE.

Math Functions

NameDescription
Excel ABS FunctionConverts a number into an absolute number.
Excel EVEN FunctionRounds a number to the nearest even number.
Excel INT FunctionReturns the integer part from the value supplied.
Excel MOD FunctionReturns the remainder value after dividing a number with a divisor.
Excel MROUND FunctionRounds a number to a given multiple.
Excel RAND FunctionReturns a random number ranging from 0 to 1.
Excel SUM FunctionSum the value supplied.
Excel SUMIF FunctionSum the value supplied using the condition specified.
Excel SUMIFS FunctionSum the value supplied using the multiple conditions specified.
Excel SUMPRODUCT FunctionMultiply and sum the array values.
Excel TRUNC FunctionReturns a number after truncating the original number.

Statistical Functions

NameDescription
Excel AVERAGE FunctionCalculates the average of the supplied numeric values.
Excel AVERAGEA FunctionCalculates the average of the supplied numeric values, boolean, and numbers formated as text.
Excel AVERAGEIF FunctionCalculates the average of the numbers based on the conditions you specify.
Excel AVERAGEIFS FunctionCalculates the average of the numbers based on the multiple conditions you specify.
Excel COUNT FunctionCounts the supplied numeric values.
Excel COUNTA FunctionCounts the supplied values except for blanks.
Excel COUNTBLANK FunctionCounts the blank values.
Excel COUNTIF FunctionCounts the values supplied using the condition specified.
Excel COUNTIFS FunctionCounts the values supplied using the multiple conditions specified.
Excel MAX FunctionReturns the maximum value from a list of values.
Excel MIN FunctionReturns the minimum value from a list of values.

Lookup Functions

NameDescription
Excel ADDRESS FunctionCreates a valid cell reference as per the supplied row and column.
Excel AREAS FunctionCounts the number of ranges in the supplied reference.
Excel CHOOSE FunctionReturns a value from a list of values using the index number.
Excel COLUMN FunctionReturns the column number of the referred cell.
Excel COLUMNS FunctionCount columns referred to in the supplied range.
Excel FORMULATEXT FunctionReturns the formulas from the cell referred to.
Excel HLOOKUP FunctionLookups for a value in the top row of a table and returns the value from the same column using an index number.
Excel HYPERLINK FunctionCreate a text with the hyperlink using the link specified.
Excel INDEX FunctionReturns a value from a list using the index number of that value in the list.
Excel INDIRECT FunctionCreate a valid cell reference from the text supplied.
Excel LOOKUP FunctionLookup for a valuer from a row, column, or an array. 
Excel MATCH FunctionReturns the index number of the value from the list of values.
Excel OFFSET FunctionReturns a reference to a range which is a specific number of rows and columns away from a cell or range of cells.
Excel ROW FunctionReturns the row number of the referred cell.
Excel ROWS FunctionCount rows referred to in the supplied range.
Excel TRANSPOSE FunctionChanges the orientation of a range.
Excel VLOOKUP FunctionLookups 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

NameDescription
Excel CELL FunctionReturns specific information about the cell referred to.
Excel ERROR.TYPE FunctionReturns a number that represents the error.
Excel INFO FunctionReturns information about the current operating environment.
Excel ISBLANK FunctionChecks if the supplied value is blank and returns TRUE.
Excel ISERR FunctionChecks if the supplied value is an error other than #N/A and returns TRUE.
Excel ISERROR FunctionChecks if the supplied value is an error and returns TRUE.
Excel ISEVEN FunctionChecks if the supplied value is an even number and returns TRUE.
Excel ISFORMULA FunctionChecks if the supplied value is a formula and returns TRUE.
Excel ISLOGICAL FunctionChecks if the supplied value is logical value and returns TRUE.
Excel ISNA FunctionChecks if the supplied value is an #N/A and returns TRUE.
Excel ISNONTEXT FunctionChecks if the supplied value is a non-text value and returns TRUE.
Excel ISNUMBER FunctionChecks if the supplied value is number and returns TRUE.
Excel ISODD FunctionChecks if the supplied value is an odd number and returns TRUE.
Excel ISREF FunctionChecks if the supplied value is a reference and returns TRUE.
Excel ISTEXT FunctionChecks if the supplied value is a text and returns TRUE.
Excel N FunctionConverts a boolean to a number.
Excel NA FunctionReturns the #N/A.
Excel SHEET FunctionReturns the sheet number of the referred cell.
Excel SHEETS FunctionCounts the number of sheets in the reference.
Excel TYPE FunctionChecks a value for an error and returns a number to represent it.

Financial Functions

NameDescription
Excel FV FunctionCalculates the future value of an investment.
Excel PMT FunctionCalculate a periodic payment of loan which you need to pay.
Excel PV FunctionCalculates the present value of financial investment or a loan.

Learn More

103 thoughts

Leave a Comment

Your email address will not be published.

  1. 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.

    Reply
  2. 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?

    Reply
  3. 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.

    Reply
  4. 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.

    Reply
  5. Sir, very useful information,notes and formula you have given.User like me would appreciate the work.
    Once again thanks.

    Reply
  6. 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.

    Reply
  7. 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.

    Reply
  8. 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.

    Reply
  9. Thank you so much Puneet Gogia and nice to see the whole functions list in online,it is helpful to me.I’m really appreciate to you… i want to learn VBA pls need you guideline (confusion in coding)

    Reply
  10. Hi, Dear Punit,

    I am very thankful to you as you have start this learning portal for all. In my office people are jealous they don’t give me chance to learn excel and no one guide me how to use excel smartly even though many of them are working smartly in excel. But from your this web portal i will be able to use excel smartly and efficiently. Thanks a lot again.

    Reply
  11. (Maraming salamat po sayo Puneet..) Thank you so much Puneet. It’s a great help for me to learn more from you

    Reply
  12. It will be better if you put more information about Excel macros. Thank you for your contributions in order to make people’s working lives easier. Keep up the good work.

    Reply
    • Sir it was done manually just to let you explain my actual need, please suggest function, if you can help in this regard.

      Reply
  13. Are these available in a PDF or Word File? This is a good reference, but it’s hard to remember to come back here for the information. Having them as something you can download would be really helpful.

    Reply
  14. Thank you for the valuable information…I would like to know one specific thing.
    Once we use the transpose, only values are copied. If i want to retain the values with formula in transpose function, is it possible. This is very important to keep scientific way to prove that the transpose operation done is correct. In data analytics big excel sheets are handled and a small mistake can lead to big problems .. Please advise me ..

    Reply
  15. with transpose function can we reverse the data set; like AAA, BBB, CCC transpose to CCC,BBB,AAA. Thanks

    Reply
  16. HI, is there any way to work out how long there is between 2 times? ie. 09:42 and 10:01 (that is, I want it to show 19 minutes)

    Reply
  17. SUBTOTAL – which I find is a powerful function, but often overlooked – particularly with the different function numbers that formula uses.

    Reply
  18. Punnet thanks, May I suggest this, an average subscriber fairly uses excel and functions but in isolation. Every one knows match, offset etc what most need is the combination of these functions to generate more potent practical problem solving forces is the next step I will like you to do after these functions in isolation.

    Reply
  19. I would love others to learn these functions “Indirect, Offset, Match, Index, Vlookup, Mid, Find, Replace, Substitute, Sumif, Sumifs, SumProduct mainly and of course array functions as well.

    Reply
  20. I would really like to have a better understanding of the Indirect with Row and/or Columns function. Could we include these please.

    Reply
  21. Hi Puneet, I saw someone at work using both the INDEX and MATCH functions. I see that someone has already requested MATCH so if possible, I would like to see INDEX added to the list. Thank you!

    Reply
  22. Hello again, Puneet (and congratulations on your 1st 1,000 subscribers)! I would like to see the IFERROR function covered. I am just learning about it, so all lessons are greatly appreciated. Thank you for asking!

    Reply
  23. Nice to see the whole functions list..would appreciate if you let us know the complete descriptions of all functions.

    Reply