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

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

M

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

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.