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
D
E
F
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
K
- KURT - Returns the kurtosis (descriptive statistics) of a data set.
L
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
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
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