Handbook of commonly used functions (formulas) in Microsoft Excel

The formulas (functions) in Excel are structures that allow you to perform calculations, return information, manipulate the data cells, test conditions, etc. In Microsoft Excel formulas there are four types of operators: arithmetic, text, comparison operators and reference operators.

The formula in Microsoft Excel always begins with an equal sign (=). The equal sign indicates that the succeeding characters constitute a formula. Formula in Excel calculates from left to right in the order specified for each operator in the formula.

Below are the group of formulas according to the Microsoft Excel. Each formula has the author's article on the use of this function.

Statistical functions in EXCEL

Statistical functions in EXCEL
EXCEL Functions: COUNT
EXCEL Functions: COUNTA - Count text values
EXCEL Functions: COUNTIF - Count based on single criteria
EXCEL Functions: COUNTIFS - Count based on multiple criterias
EXCEL Functions: MIN
EXCEL Functions: MAX
EXCEL Functions: LARGE
EXCEL Functions: SMALL
EXCEL Functions: AVERAGE - arithmetic mean
EXCEL Functions: AVERAGEIF - arithmetic mean based on multiple conditions
EXCEL Functions: GEOMEAN - geometric mean of an array of positive data
EXCEL Functions: FREQUENCY
EXCEL Functions: COUNTBLANK
EXCEL Functions: RANK

Excel Financial Functions

Excel Financial Functions
EXCEL Functions: PMT

Date and Time Functions in EXCEL

Date and Time Functions in EXCEL
EXCEL Functions: DATE
EXCEL Functions: YEAR
EXCEL Functions: MONTH
EXCEL Functions: DAY
EXCEL Functions: DATEDIF - Calculates the number of days, months, or years between two dates
EXCEL Functions: DATEVALUE
EXCEL Functions: EDATE
EXCEL Functions: EOMONTH
EXCEL Functions: WEEKDAY
EXCEL Functions: WEEKNUM
EXCEL Functions: WORKDAY
EXCEL Functions: NETWORKDAYS
EXCEL Functions: TIMEVALUE
EXCEL Functions: TIME
EXCEL Functions: TODAY

Lookup and Reference Functions in EXCEL

Lookup and Reference Functions in EXCEL
EXCEL Functions: ROW
EXCEL Functions: COLUMN
EXCEL Functions: OFFSET
EXCEL Functions: INDEX
EXCEL Functions: MATCH
EXCEL Functions: VLOOKUP
EXCEL Functions: INDIRECT
EXCEL Functions: ADDRESS
EXCEL Functions: LOOKUP
EXCEL Functions: CHOOSE
EXCEL Functions: ROWS
EXCEL Functions: TRANSPOSE
EXCEL Functions: HYPERLINK

Excel Information Functions

Excel Information Functions
EXCEL Functions: ISERR
EXCEL Functions: ISERROR
EXCEL Functions: ISNA
EXCEL Functions: NA
EXCEL Functions: ISNUMBER
EXCEL Functions: ISTEXT
EXCEL Functions: ISBLANK
EXCEL Functions: CELL

Database functions in EXCEL

Database functions in EXCEL
EXCEL Functions: DCOUNT - Count based on multiple conditions
EXCEL Functions: DSUM - Sum based on multiple conditions
EXCEL Functions: DGET
EXCEL Functions: DCOUNTA - Count text values based on multiple conditions
EXCEL Functions: DMAX - largest number that matches conditions
EXCEL Functions: DMIN - smallest number that matches conditions
EXCEL Functions: DAVERAGE - Average values based on multiple conditions

Excel Logical Functions

Excel Logical Functions
EXCEL Functions: IF
EXCEL Functions: IFERROR
EXCEL Functions: OR
EXCEL Functions: AND
EXCEL Functions: NOT

Math and Trig Functions in EXCEL

Math and Trig Functions in EXCEL
EXCEL Functions: SUM
EXCEL Functions: SUMIF - Sum based on single criteria
EXCEL Functions: SUMIFS - Sum based on multiple criterias
EXCEL Functions: SUMPRODUCT - Sum and count based on multiple criterias
EXCEL Functions: ROUND
EXCEL Functions: ROUNDUP
EXCEL Functions: ROUNDDOWN
EXCEL Functions: MROUND
EXCEL Functions: INT
EXCEL Functions: MOD
EXCEL Functions: TRUNC
EXCEL Functions: ODD
EXCEL Functions: EVEN
EXCEL Functions: RANDBETWEEN - returns a random integer between given numbers
EXCEL Functions: RAND - returns a random number between 0 and 1
EXCEL Functions: RAND
EXCEL Functions: ROMAN
EXCEL Functions: SUBTOTAL

Excel Text Functions

Excel Text Functions
EXCEL Functions: FIXED
EXCEL Functions: TEXT
EXCEL Functions: VALUE
EXCEL Functions: LEN
EXCEL Functions: REPLACE
EXCEL Functions: CODE
EXCEL Functions: LEFT
EXCEL Functions: RIGHT
EXCEL Functions: FIND
EXCEL Functions: SEARCH
EXCEL Functions: SUBSTITUTE
EXCEL Functions: UPPER
EXCEL Functions: PROPER
EXCEL Functions: MID
EXCEL Functions: REPT
EXCEL Functions: EXACT
EXCEL Functions: LOWER
EXCEL Functions: TRIM