Basic Microsoft Excel Functions

Basic Microsoft Excel functions. Click the letter to go to functions that start with it or use the browsers find function using Ctrl+F (Cmd+F on Mac) to find the function by typing its first few letters of the function name.

This is the best place for Excel beginners to familiarize themselves with basic Excel functions. Each Function has been explained in detail with an example and infographic. If you did not find any function here, then please use our Suggestion Form.

ABCDEFGHIKLMNOPQRSTUVWXYZ
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.
  • AMORDEGRC - Returns the linear depreciation of an asset for each accounting period, on a prorated basis.
  • 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.
  • AVERAGEA - AVERAGEA Function returns the average (arithmetic mean) of the arguments. The number arguments are a set of one or more numeric values, or arrays of numeric values, for which you want to calculate the average. It includes the range or a cell reference argument containing text, logical values or empty cells. It also will include […]
B
  • BASE - Converts a number into Text representation with a given Radix or base.
C
  • COMPLEX - Converts coefficients (real and imaginary) into a complex number.
  • COUNT - Counts the cells which contain number only.
  • COUNTA - Counts the number of non-empty cells in a selected range.
  • CUMIPMT - Returns the cumulative interest paid on a loan between start_period and end_period.
  • CUMPRINC - Returns the cumulative principal paid on a loan between start_period and end_period.
D
  • DATE - Returns a date, from a user-supplied year, month and day.
  • DATEDIF - Calculates the number of days, months, or years between two dates.
  • DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
  • DCOUNT - Returns the number of cells in a column or database that contains numeric values and meets a given criteria.
  • DDB - Calculates depreciation of an asset for a specified period using the double-declining balance method
  • DOLLARDE - Converts a dollar value in fractional notation, into a dollar value expressed as a decimal.
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
  • FACT - Returns the factorial value of a supplied number. Factorial number = 1*2*3*...* number.
  • 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.
  • FVSCHEDULE - Returns the future value of an initial principal after applying a series of compound interest rates.
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
  • INT - Rounds a number down to the nearest integer.
  • INTRATE - Calculates the interest rate for a fully invested security.
  • IPMT - Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
  • 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
  • MAX - Returns the largest value in a set of values.
  • MID - Returns a specific number of characters from a text string at the specified starting position and specified number of characters.
  • MIN - Returns the smallest value from the numbers provided.
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.
  • NOW - The NOW Function returns the current date and the current time of the system.
O
  • OR - Logical comparison within an IF function any one of the arguments to be true.
P
  • POWER - Returns the result of a number raised to a power. The "^" operator can be used instead of POWER to indicate to what power the base number is to be raised.
  • 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).
  • PV - Calculates the present value of a loan or an investment, based on a constant interest rate.
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.
  • RANK - Returns the rank of a number in a list of numbers.
  • RECEIVED - Calculates the amount received at maturity for a fully invested security.
  • 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.
  • SLN - Returns the depreciation of an asset for a period based on the straight-line depreciation method.
  • SQRT - Calculates the positive square root of a supplied number.
  • SUBSTITUTE - To replace text based on its content but not the position.
  • SUBTOTAL - Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of values.
  • SUM With Comma - To add values of two cell or numbers separated by Comma.
T
  • TODAY - Returns the current system date.
  • 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.

ExcelDataPro

Free Excel Pro Templates