# 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.

### 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

 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

### 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 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

### 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

### 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 Logical Functions

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

### Excel Financial Functions

 EXCEL Functions: PMT

### 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