# ExpFunctions

HintText:
Returns a numeric value that is the ANSI code for the first character in a string expression.


HintText:
ArcTangent of a number.  Takes the ratio of two sides of a right triangle and returns the corresponding angle.


HintText:
Returns a one-character string whose ANSI code is the argument.


HintText:
Cosine of an angle, measured in radians.


HintText:
Returns a Variant of type Date to which a specified time interval has been added.


HintText:
Returns a Variant that contains the number of time intervals between two specified dates.


HintText:
Returns a specified part of a given date.


HintText:
Returns the date serial for a specific year, month, and day.


HintText:
Returns the date represented by the date of a String argument.


HintText:
Returns an integer between 1 and 31, inclusive, that represents the day of the month for a date argument.


HintText:
Depreciation of an asset for a specific period using the double-declining balance method.


HintText:
e (the base of natural logarithms) raised to a power.


HintText:
Returns the integer portion of a number, removing any fractional part.  If negative, returns the first negative integer >= number.  See also Int.


HintText:
Format a number, date, time, or string according to instructions contained in a format expression.


HintText:
Future value of an annuity based on periodic, constant payments and a constant interest rate.


HintText:
Returns the position of the first occurrence of one string within another.


HintText:
Returns the integer portion of a number, removing any fractional part.  If negative, returns the first negative integer <= number.  See also Fix.


HintText:
Interest payment for a given period of an annuity pased on periodic, constant payments and a constant interest rate.


HintText:
Internal rate of return for a series of periodic cash flows (payments and receipts).


HintText:
Returns a value indicating whether or not a Variant argument can be converted to a date.


HintText:
Return a string in which all letters of an argument have been converted to lowercase.


HintText:
Returns the leftmost n characters of a string argument.


HintText:
Natural logarithm of a number.  See also exp.


HintText:
Return a copy of a string with leading spaces removed.


HintText:
Return a string that is part of some other string.


HintText:
Modified internal rate of return for a series of periodic cash flows (payments and receipts).


HintText:
Returns a date that represents the current date and time according to the setting of the computer's system date and time.


HintText:
Number of periods for an annuity based on periodic, constant payments and a constant interest rate.


HintText:
Net present value of an investment bases of a series of periodic cash flows (payments and receipts) and a discount.


HintText:
Payment for an annuity based on periodic, constant payments and a constant interest rate.


HintText:
Present value of an annuity based on periodic, constant payments to be paid in the future and a constant interest rate.


HintText:
Interest Rate per period for an annuity.  For all argunents, cash paid out is represented by negative number; cash received by positive.


HintText:
Returns the rightmost n characters of a string argument.


HintText:
Straight-line depreciation of an asset for a single period.


HintText:
Return a string consisting of a specified number of spaces.


HintText:
Returns a variant that indicates the result of the comparison of two string arguments.


HintText:
Return a string whose characters all have a given ANSI code or are all the first character of a string expression.


HintText:
Sum-of-Years-Digits depreciation of an asset for a specified period.


HintText:
Returns the number of seconds that have elapsed since 12:00 AM (midnight).


HintText:
Return a copy of a string with leading and trailing spaces removed.


HintText:
Returns a string in which all the letters have been converted to upper case.


# ExpParams

HintText:
Any valid numeric expression measured in radians.  To convert degrees to radians, multiply degrees by pi/180.  Pi is approximately 3.14159265358979323846.


HintText:
String expression that is the interval of time you want to add to «date».


HintText:
Numeric expression that is the number of intervals you want to add.  It may be positive (to get dates in the future) or negative (to get dates in the past).


HintText:
String expression that is the interval of time you use to calculate the difference between «date1» and «date2».


HintText:
First date you want to use in the calculation, or the name of a Date/Time field.


HintText:
Second date you want to use in the calculation, or the name of a Date/Time field.


HintText:
String expression that is the interval of time you want to return.


HintText:
Date that you want to inspect, or the name of a Date/Time field.


HintText:
A number between 0 and 9999, inclusive, or a numeric expression


HintText:
A number between 1 and 12, inclusive, or a numeric expression


HintText:
A number between 1 and 31, inclusive, or a numeric expression


HintText:
A string representing a date from January 1, 100 through December 31, 9999.


HintText:
Any numeric expression that can represent a date and/or time from January 1, 100 through December 31, 9999, where January 1, 1900 is 2.  Numbers to the left of the decimal point in «number» represent the date; numbers to the right represent the time.


HintText:
Value of the asset at the end of its useful life.


HintText:
Period for which asset depreciation is calculated.  Must be in same units as the life.  For example, if life is given in months, so must be period.


HintText:
Any valid numeric expression.  The data type of the returned value is the same as that of the number argument; unless number is a variant of vartype 8 (string) that can be converted to a number, the return type will be a variant of vartype 5(double).


HintText:
Numeric or string expression to be formatted.


HintText:
Format expression -- a string of display format characters that specify how the expression is to be displayed..


HintText:
Interest rate per period.  For example, if you get a car loan at an annual percentage rate (APR) of 10% and make monthly payments, the rate per period is 0.1/12, or .00833.


HintText:
Total number of payment periods in the annuity.  For example, if you make monthly payments on a four-year car loan, your loan has a total of 4*12, or 48, periods.


HintText:
Payment to be made each period.  Payments usually contain principal and interest that doesn't change over the life of the annuity.


HintText:
Present value (or lump sum) that a series of payments to be paid in the future is worth now.  For example, when you borrow money to buy a car, the loan amount is the present value.


HintText:
Number indicating when payments are due.  Use 0 if payments are due at the end of the payment period; use 1 if due at beginning.


HintText:
Numeric expression that sets the starting position for each search.


HintText:
.Payment period in the range 1 through nper.


HintText:
Total number of payment periods in the annuity.  For example, if you make monthly payments on a four-year car loan, your loan has a total of 4*12, or 48, periods


HintText:
Future value or cash balance you want after you've made the final payment.  The future value of a loan, for instance, is $0.  As another example, if you will need $50,000 in 18 years for school, then $50,000 is the future value.


HintText:
Array of cashflow values.  The array must contain at least one negative value (a payment) and one positive value (a receipt).


HintText:
Approximate value you guess will be returned by Irr.


HintText:
Can be any Variant expression of VarType Date or of VarType String.


HintText:
String Expression to determine the lenght of.


HintText:
String expression from which another string is created.  Hey!  What this means is that this is the string you want part of.


HintText:
Character position in string at which the part to be taken begins.


HintText:
Interest rate paid as the cost of financing, expressed as decimal value.  For example, 12% is expressed as 0.12.


HintText:
Interest rate received on gains from cash reinvestment, expressed as decimal value.  For example, 12% is expressed as 0.12.


HintText:
Discount rate over the length of the period, expressed as a decimal.


HintText:
Array of cash flow values.  Must contain at least one negative value (payment) and at least one positive value (receipt).


HintText:
Payment period in the range 1 through nper.


HintText:
Approximate value you guess will be returned by Rate.


HintText:
Returns the leftmost n characters of a string argument.


HintText:
Any valid numeric expression.  The value of number determines how Rnd generates a random number.  (<0 : the same number every time.  >0: the next random number in the sequence.  =0: the number most recently generated.)


HintText:
Any valid numeric expression.  Its sign determines the value returned by the Sgn function.  For example,  Libra returns the value 10.


HintText:
Must be between 0 and approximately 65,535.


HintText:
Any valid numeric expression that evaluates to a value greater than or equal to zero.


HintText:
0, 1, 2 or the value of the CollatingOrder field returned by the list fields method.


