Press "Enter" to skip to content

List of Top Used Excel Functions

Hereby, I am sharing the list of the most important and frequently used excel functions (along with a brief description of use) for your reference. I am sure this list will be a great resource for you. Please feel free to contact me if face any problem in understanding any of these functions mentioned below.

Excel Function Description of the given function
ABS()Return the absolute value of the given number. In simple words, it will convert Negative numbers into Positive and Positive numbers will remain the same.
AGGREGATE()It applies to functions like Count, Max, Sum, Min etc for ignoring erros and hidden rows and columns while doing the calculation.
AND()It’s a logical function that returns two values only either True or False, provided all the given conditions are met.
AVERAGE()Return the average of the numbers provided
AVERAGEIF()Return the average of the numbers provided the given criteria is full-filled
AVERAGEIFS()Return the average of the numbers provided all the given criterias are full-filled
AVEDEV()Returns the average of the absolute deviations of the numbers provided
CELL()Return the informations like Address, Color etc for the given cell in the worksheet.
CLEAN ()Remove all non-printable characters from the given text
CODE()Return the numeric code for the first character of the given text. You can use this function to identify the type of character used if CLEAN function can’t removed it.
COLUMN()Return the Column Number for the given reference
COLUMNS()Return the total number of columns in the given range.
CONVERT()Convert one unit into another given unit. For example, you can use this function to convert a number from Meter into Centimeter
COUNT()Count the number of cells which includes numbers in it
COUNTA()Count the number of cells which are not empty
COUNTBLANK()Count the number of cells which are blank
COUNTIF()Counts the number of cells in a range, that met a given criteria
COUNTIFS()Counts the number of cells in a range, that met a Single or Multiple criteria(s)
CHOOSE()Return a value from a list using a given position or Index. For example, CHOOSE (2, “White”, “Green”, “Yellow”) will return Green as the answer.
DATEVALUE()Returne the serial number of the given date
DAY()Return the value of ‘Day’ from the given ‘Date’. For example, this function will return ‘2’ as an answer for the date (02/02/20202)
DAYS()Return the numbers of days between two dates
DAYS()Return the numbers of days between two dates considering 360 days per year that is 30 days per month
EDATE()Adds a specified number of months to a date and returns the result as a serial date
EVEN()Round a positive number to up and negative numbers to down to the nearest even number
EXACT()Return whether the given two numbers or text are exactly same or not. Remember, this function is case sensitive
EOMONTH()Return the serial number of the last date of the month after adding before and after the specified number of months to the given date
FALSE()Return False as answer
FIND()Return the location of the specified string/character from the given text. Remember, this is case sensitive
FIXED()Round a number to a specific decimals and has option to display the number with comma or without comma
FORMULATEXT()Convert a given formula into text. This function is useful to check the formula written in the given cell
GCD()Return the greatest common divider for the given numbers
GETPIVOTDATA()Extract data stored in the Pivot Table
HLOOKUP()Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number
HOUR()Return the hours in serial number ranging from 0 to 23
HYPERLINK()Create a Hyperlink
IF()Check whether the give condition is met and return the  given value if True or else return another value if the answer is False
IFERROR()Return the given value in case of error
IFNA()Return the given value in case of #NA
INDEX()Return a value or reference of cells from the intersection of the given row and column
INDIRECT()Return a reference represented by the text string
INT()Convert the number to nearest integer
ISBLANK()Check whether the given cell is blank or not? Return True if it is blank or else False
ISERR()Used to check for error values except #N/A. It return the answer as True or False
ISEVEN()Used to check whether the given number is even or not?
ISFORMULA()Used of check whether the cells contain formula or not?
ISODD()Used to check whether the given number is odd or not?
ISNUMBER()Used to check whether the given number is Number or not?
ISNONTEXT()Used to check for a value that is not text ( Blank cell is non-text)?
ISLOGICAL()Used to check whether the given value is logical or not?
LARGE()Return the nth largest number from the given range.
LEFT()Return the specific number of characters starting from left from the given text string
LEN()Return the number of characters in the given string
LOOKUP()Returns a value from a range (one row or one column) or from an array
LOWER()Convert the given text into lowercase
MATCH()Searches for a value in an array and returns the relative position of that item
MAX()Return the maximum value from the given range ignoring logical and text
MAXA()Return the maximum value from the given range considering logical and text as well
MID()Return the Characters from the middle of the string mentioning the starting position and number of characters
MIN()Return the minimum value from the given range ignoring logical and text
MINA()Return the minimum value from the given range considering logical and text as well
MOD()Return the reminder after a number is divided by the divisor
MONTH()Return the serial number of the given month
N()Convert Non-Number in to number, Date into serial, True into 1 and rest into Zero (0)
NA()Return the answer #NA
NOT()Change False into True and vice versa
NOW()Return the current date and time
ODD()Round a positive number to up and negative numbers to down to the nearest Odd number
OFFSET()Returns a reference to a range that is offset a number of rows and columns
OR()It’s a logical function that returns two value only either True or False based on any of the given conditions is full-filled
QUOTIENT()Return the integer position of the division
RAND()Generate a random number
RANDBETWEEN()Generate a random number between number specify
REPLACE()Used to replace the given string with different string
RIGHT()Return the specific number of characters starting from the right side from the given text string
ROUND()Round a number to a specific number of decimals
ROUNDDOWN()Round a number down toward zero
ROUNDUP()Round a number up away from zero
ROW()Return the Row Number for the given reference
ROWS()Return the total number of rows in the given range.
SEARCH()Return the number of characters at which the specific character is found first in the given string starting left to right. This is a non-sensitive function
SECOND()Return the serial number of the second ranging between 0 to 59
SHEET()Return the serial number of the reference Worksheet
SHEETS()Return the number of sheets in a given range or reference
SIGN()Return the sign of the given number. 1 if it is positive and 0 if it is negative
SMALL()Return the nth smallest number from the given range 
SUBTOTAL()Returns the subtotal of the numbers in a column in a list or database
SUBSTITUTE()Substitute the given text with a new text in the given text string
SUM()Return the sum total of the given numbers
SUMIF()Return the sum total of the given numbers provided given conditions met
TIME()Returns a decimal number given an hour, minute and the second value
TIMEVALUE()Returns the serial number of a time
TODAY()Returns the current system date
TRANSPOSE()Transpose horizontal data into vertical and vice versa
TRIM()Trim off all the spaces except one space between the words
TRUNC()Truncated the number into  integers by removing the decimal and fraction
TRUE()Return True as answer
UPPER()Convert all the characters in the given string into uppercase
VLOOKUP()Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position
WEEKDAY()Return the serial number of the Weekday ranging between 0 to 7
WEEKNUM()Return the serial number of week within the given year
WORKDAY()Adds a specified number of work days to a date and returns the result as a serial date
YEAR()Return the serial number of the year ranging between 1900 to 9999

Leave a Reply

Your email address will not be published. Required fields are marked *