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.
| CUBERANKEDMEMBER | Cube |
 |
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students. |
| CUBESET | Cube |
|
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. |
| CUBESETCOUNT | Cube |
|
Returns the number of items in a set. |
| CUBEVALUE | Cube |
|
Returns an aggregated value from a cube. |
| CUMIPMT | Financial |
|
Returns the cumulative interest paid between two periods |
| CUMPRINC | Financial |
|
Returns the cumulative principal paid on a loan between two periods |
| DATE | Date and time |
|
Returns the serial number of a particular date |
| DATEDIF | Date and time |
|
Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. |
| DATEVALUE | Date and time |
|
Converts a date in the form of text to a serial number |
| DAVERAGE | Database |
|
Returns the average of selected database entries |
| DAY | Date and time |
|
Converts a serial number to a day of the month |
| DAYS | Date and time |
|
Returns the number of days between two dates |
| DAYS360 | Date and time |
|
Calculates the number of days between two dates based on a 360-day year |
| DB | Financial |
|
Returns the depreciation of an asset for a specified period by using the fixed-declining balance method |
| DBCS | Text |
|
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
| DCOUNT | Database |
|
Counts the cells that contain numbers in a database |
| DCOUNTA | Database |
|
Counts nonblank cells in a database |
| DDB | Financial |
|
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify |
| DEC2BIN | Engineering |
|
Converts a decimal number to binary |
| DEC2HEX | Engineering |
|
Converts a decimal number to hexadecimal |
