|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Returns the amount of each regular payment for an investment with fixed interest rate and fixed payment. |
|
|
|
|
|
|
|
| Returns the name of the day that corresponds to a specified date (this date is an integer). |
|
|
|
|
|
|
|
| Returns the number of payments required to pay off a capital according to a given rate. |
|
|
|
|
|
|
|
| Returns the day of the week that corresponds to the specified date (this date is an integer). |
|
|
|
|
|
|
|
| Calculates the interest rate for a loan over a specific period of time with fixed payments. |
|
|
|
|
|
|
|
| Converts an integer into a time in HHMMSSCC format. |
|
|
|
|
|
|
|
| Returns the current value of investment. |
|
|
|
|
|
|
|
| Converts an integer into a date in YYYYMMDD format. |
|
|
|
|
|
|
|
| Returns the net current value of investment. |
|
|
|
|
|
|
|
| Converts a duration to a character string in the specified format. |
|
|
|
|
|
|
|
| Returns the future value of an investment. |
|
|
|
|
|
|
|
| Returns the week number within the year that corresponds to the specified date. |
|
|
|
|
|
|
|
| Calculates for a given period the amount of interests due for a loan paid off by fixed periodic payments with a fixed interest rate. |
|
|
|
|
|
|
|
| Returns the name of the month that corresponds to a specified date. |
|
|
|
|
|
|
|
| Returns the absolute value:
of a numeric value,
of a numeric expression (integer or real).
of a duration.... |
|
|
|
|
|
|
|
| Returns the name of the day that corresponds to a specified date. |
|
|
|
|
|
|
|
| Returns the arc cosine of a numeric value (integer or real). |
|
|
|
|
|
|
|
| Returns the day that corresponds to a given date. |
|
|
|
|
|
|
|
| Returns the arc sine of a numeric value (integer or real). |
|
|
|
|
|
|
|
| Converts a date to an integer. |
|
|
|
|
|
|
|
| Returns the arc tangent of a numeric value (integer or real). |
|
|
|
|
|
|
|
| Converts:
a date to a string in the specified format.
a date time to a string in the specified format.... |
|
|
|
|
|
|
|
| Returns the rounded value of a numeric value according to the specified number of decimal places. |
|
|
|
|
|
|
|
| Checks the validity of a date between January 01 0001 and December 31 9999. |
|
|
|
|
|
|
|
| Returns or modifies the system date (current date defined on the current computer). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|