Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
| DEC2OCT | Engineering |
 |
Converts a decimal number to octal |
| DECIMAL | Math and trigonometry |
|
Converts a text representation of a number in a given base into a decimal number |
| DEGREES | Math and trigonometry |
|
Converts radians to degrees |
| DELTA | Engineering |
|
Tests whether two values are equal |
| DEVSQ | Statistical |
|
Returns the sum of squares of deviations |
| DGET | Database |
|
Extracts from a database a single record that matches the specified criteria |
| DISC | Financial |
|
Returns the discount rate for a security |
| DMAX | Database |
|
Returns the maximum value from selected database entries |
| DMIN | Database |
|
Returns the minimum value from selected database entries |
| DOLLAR | Text |
|
Converts a number to text, using the $ (dollar) currency format |
| DOLLARDE | Financial |
|
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number |
| DOLLARFR | Financial |
|
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction |
| DPRODUCT | Database |
|
Multiplies the values in a particular field of records that match the criteria in a database |
| DSTDEV | Database |
|
Estimates the standard deviation based on a sample of selected database entries |
| DSTDEVP | Database |
|
Calculates the standard deviation based on the entire population of selected database entries |
| DSUM | Database |
|
Adds the numbers in the field column of records in the database that match the criteria |
| DURATION | Financial |
|
Returns the annual duration of a security with periodic interest payments |
| DVAR | Database |
|
Estimates variance based on a sample from selected database entries |
| DVARP | Database |
|
Calculates variance based on the entire population of selected database entries |
| EDATE | Date and time |
|
Returns the serial number of the date that is the indicated number of months before or after the start date |
