Excel Data Pro: "Common Excel Functions"

Glance at this glossary of to discover other functions available in Excel. Test a few of these out in an Excel worksheet. Notice that when you enter "=" and a letter, a list of possible functions will appear.

A
  • ABS - Returns the absolute value of any supplied number.
  • ACCRINT - Returns the accrued interest for a security/investment that pays interest on a periodic basis.
  • ACCRINTM - Returns the accrued interest for a security that pays interest at maturity.
  • AMORLINC - Returns the depreciation for each accounting period. This function is provided for the French accounting system.
  • AVERAGE - Returns the Average (arithmetic mean) of a list of supplied numbers.
B
  • BASE - Converts a number into Text representation with a given Radix or base.
C
  • COUNT - Counts the cells which contain number only.
  • COUNTA - Counts the number of non-empty cells in a selected range.
D
  • DATE - Returns a date, from a user-supplied year, month and day.
  • DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
E
  • EDATE - Adds the specified number of months to a date and returns the result as a future or past date.
  • EOMONTH - Calculates the last date of a month from a given start date.
  • EXACT - Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.
F
  • FLOOR - Rounds the number down, toward zero, to the nearest multiple of significance.
  • FV - Returns the future value of an investment based on an interest rate and a constant payment schedule.
G
  • GCD - Returns the greatest common divisor of two or more supplied integers.
H
  • HOUR - To extract the hour value as an integer from valid time/date value
I
  • ISODD - Returns TRUE if the number is odd, or FALSE if the number is even.
  • ISTEXT - Test the contents of a cell before performing a calculation.
K
  • KURT - Returns the kurtosis (descriptive statistics) of a data set.
L
  • LCM - Returns the least common multiple of two or more supplied integers.
  • LOWER - To change the text from upper case (ABC) or proper case (Abc) to lower case (abc).
M
  • MID - Returns a specific number of characters from a text string at the specified starting position and specified number of characters.
N
  • NETWORKDAYS - Calculates the total number of working days between two dates.
  • NOT - logical comparison within an IF functions for more than one arguments to be true.
O
  • OR - Logical comparison within an IF function any one of the arguments to be true.
P
  • PRODUCT - Returns the product (multiplication) of a supplied set of numerical values.
  • PROPER - To change the text from lower case (abc) or upper case (ABC) to Proper case (Abc).
Q
  • QUOTIENT - Returns the integer portion of a division between two supplied numbers.
R
  • RANDBETWEEN - Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.
  • REPLACE - Replaces a sequence of characters in a string with another set of characters.
  • ROUNDDOWN - Returns a number rounded down to a specified number of digits.
  • ROUNDUP - ROUNDUP Function rounds the integers upward
S
  • SEARCH - Get the location of one text string inside another.
  • SUBSTITUTE - To replace text based on its content but not the position.
  • SUM With Comma - To add values of two cell or numbers separated by Comma.
T
  • TRIM - Removes extra spaces in a cell whether at beginning, trailing or between the words.
  • TRUNC - Returns a number truncated to a specified number of digits.
U
  • UPPER - To change the text from lower case (abc) or proper case (Abc) to upper case (ABC).
V
  • VALUE - Converts a text string that represents a number to a number.
W
  • WEEKNUM - Return the number of a week for a given date in that particular year.
X
  • XIRR - Returns the Internal Rate of Return for a supplied series of cash flows (i.e. a set of values, which includes an initial investment value and a series of net income values).
Y
  • YEARFRAC - Returns the number of days between 2 dates as a year fraction.
Z
  • ZTEST - Returns the one-tailed probability value of a z-test.
Last modified: Monday, March 13, 2017, 11:19 AM