Home / Excel Functions

Excel Functions List (Top 100) Examples + Sample Files

Table of Content Close
1. Excel String (Text) Functions
2. Excel Date Functions
3. Excel Time Functions
4. Excel Logical Functions
5. Excel Math Functions
6. Excel Statistical Functions
7. Excel Lookup Functions
8. Excel Information Functions
9. Excel Financial Functions
More Excel Tutorials

1. Excel String (Text) Functions

  • FIND Function: Returns the starting position of a text string in another text string (case sensitive).
  • LEFT Function: Returns the string from another string starting from the left.
  • LEN Function: Counts the number of characters from the value supplied.
  • LOWER Function: Converts a text into lower case.
  • MID Function: Returns a substring from a string using a specific position and number of characters.
  • PROPER Function: Convert a text to a proper case text.
  • REPT Function: Repeats a value several times.
  • RIGHT Function: Returns the string from another string starting from the right.
  • SEARCH Function: Returns the starting position of a text string in another text string (case sensitive).
  • UPPER Function: Convert a text into an upper case text.

2. Excel Date Functions

  • DATE Function: Returns a valid date using the day, month, and year supplied.
  • DATEDIF Function: Calculates the difference between two dates.
  • DATEVALUE Function: Converts a date that is formatted as text into an actual date.
  • DAY Function: Returns the day from the date supplied.
  • DAYS Function: Returns the count of days between two dates.
  • EDATE Function: Returns a date after adding/subtracting months from the supplied date.
  • EOMONTH Function: Returns the end of the month date from a future month or a past month.
  • MONTH Function: Returns the month from the date supplied.
  • NETWORKDAYS Function: Count of days between the start date and end date, excluding weekends and holidays.
  • NETWORKDAYS.INTL Function: Count of days between the start date and end date, excluding weekends (Custom), and holidays.

3. Excel Time Functions

  • HOUR Function: Returns the hours from the time supplied.
  • MINUTE Function: Returns the minutes from the time supplied.
  • NOW Function: Returns the current date and time.
  • SECOND Function: Returns the seconds from the time supplied.
  • TIME Function: Returns a valid time using the hours, minutes, and seconds supplied.
  • TIMEVALUE Function: Convert a time value that is stored as text into actual time.

4. Excel Logical Functions

  • AND Function: Test multiple conditions and return TRUE if all the conditions are TRUE.
  • FALSE Function: Returns the boolean value FALSE.
  • IF Function: Tests a condition and returns a value if that condition is TRUE else some other value.
  • IFERROR Function: Tests a value for an error and returns the specified value if an error occurred, else returns the original value.
  • IFNA Function: Tests a value for #N/A error and returns the specified value if the error occurred, else returns the original value.
  • NOT Function: Reverse a logical result/value.
  • OR Function: Test multiple conditions and return TRUE if any of the conditions are TRUE.
  • TRUE Function: Returns the boolean value TRUE.

5. Excel Math Functions

  1. ABS: Converts a number into an absolute number.
  2. EVEN: Rounds a number to the nearest even number.
  3. INT: Returns the integer part from the value supplied.
  4. MOD: Returns the remainder value after dividing a number with a divisor.
  5. MROUND: Rounds a number to a given multiple.
  6. RAND: Returns a random number ranging from 0 to 1.
  7. SUM: Sum the value supplied.
  8. SUMIF: Sum the value supplied using the condition specified.
  9. SUMIFS: Sum the value supplied using the multiple conditions specified.
  10. SUMPRODUCT: Multiply and sum the array values.
  11. TRUNC: Returns a number after truncating the original number.

6. Excel Statistical Functions

  • AVERAGE Function: Calculates the average of the supplied numeric values.
  • AVERAGEA Function: Calculates the average of the supplied numeric values, Boolean, and numbers formatted as text.
  • AVERAGEIF Function: Calculates the average of the numbers based on the conditions you specify.
  • AVERAGEIFS Function: Calculates the average of the numbers based on the multiple conditions you specify.
  • COUNT Function: Counts the supplied numeric values.
  • COUNTA Function: Counts the supplied values except for blanks.
  • COUNTBLANK Function: Counts the blank values.
  • COUNTIF Function: Counts the values supplied using the condition specified.
  • COUNTIFS Function: Counts the values supplied using the multiple conditions specified.
  • MAX Function: Returns the maximum value from a list of values.
  • MIN Function: Returns the minimum value from a list of values.

7. Excel Lookup Functions

  • ADDRESS Function: Creates a valid cell reference as per the supplied row and column.
  • AREAS Function: Counts the number of ranges in the supplied reference.
  • CHOOSE Function: Returns a value from a list of values using the index number.
  • COLUMN Function: Returns the column number of the referred cell.
  • COLUMNS Function: Count columns referred to in the supplied range.
  • FORMULATEXT Function: Returns the formulas from the cell referred to.
  • 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.
  • HYPERLINK Function: Create a text with the hyperlink using the link specified.
  • INDEX Function: Returns a value from a list using the index number of that value in the list.
  • INDIRECT Function: Create a valid cell reference from the text supplied.
  • LOOKUP Function: Lookup for a valuer from a row, column, or array. 
  • MATCH Function: Returns the index number of the value from the list of values.
  • 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.
  • ROW Function: Returns the row number of the referred cell.
  • ROWS Function: Count rows referred to in the supplied range.
  • TRANSPOSE Function: Changes the orientation of a range.
  • 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.

8. Excel Information Functions

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

9. Excel Financial Functions

  • FV Function: Calculates the future value of an investment.
  • PMT Function: Calculate a periodic payment of loan which you need to pay.
  • PV Function: Calculates the present value of financial investment or a loan.

More Excel Tutorials

109 thoughts on “Excel Functions List (Top 100) Examples + Sample Files”

  1. I fancy EXCEL & where ever possible I try to programe it. PLEASE help me with all the functions & their examples. Have done it for Numerology, Family genealogy, now Family trust fund am stuck with the “AND” function of using it. Please help me.83 years age. NO Website, wish I can develop one.

    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. Function: Checks if the supplied value is blank and returns TRUE.
    ISERR Function: Checks if the supplied value is an error other than #N/A and returns TRUE.
    ISERROR Function: Checks if the supplied value is an error and returns TRUE.
    ISEVEN Function: Checks if the supplied value is an even number and returns TRUE.
    ISFORMULA Function: Checks if the supplied value is a formula and returns TRUE.
    ISLOGICAL Function: Checks if the supplied value is logical value and returns TRUE.
    ISNA Function: Checks if the supplied value is an #N/A and returns TRUE.
    ISNONTEXT Function: Checks if the supplied value is a non-text value and returns TRUE.
    ISNUMBER Function: Checks if the supplied value is a number and returns TRUE.
    ISODD Function: Checks if the supplied value is an odd number and returns TRUE.
    ISREF Function: Checks if the supplied value is a reference and returns TRU

    Reply

  4. Please help. I have a column with a title.
    If it has been checked how to I copy the title to another cell?

    Reply

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

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

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

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

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

    Reply

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

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

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

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

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

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

    Reply

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

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

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

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

    Reply

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

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

    Reply

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

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

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

    Reply

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

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

  81. i would like to Get a good description of the match function and/or the choose function. Thanks Torstein (sejohnse@yahoo.no)

    Reply

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

    Reply

Leave a Comment