Excel Functions List (Top 100) Examples + Sample Files

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

• ABS Function: Converts a number into an absolute number.
• EVEN Function: Rounds a number to the nearest even number.
• INT Function: Returns the integer part from the value supplied.
• MOD Function: Returns the remainder value after dividing a number with a divisor.
• MROUND Function: Rounds a number to a given multiple.
• RAND Function: Returns a random number ranging from 0 to 1.
• SUM Function: Sum the value supplied.
• SUMIF Function: Sum the value supplied using the condition specified.
• SUMIFS Function: Sum the value supplied using the multiple conditions specified.
• SUMPRODUCT Function: Multiply and sum the array values.
• TRUNC Function: 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 formated 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.

Article Creator : Sudip Batabyal

Email ID: [email protected]

Soni Group Of Hospitals