Free E-Books

n NumberOfPayments is an Integer indicating how many payments are made over the
life of the annuity.
n PresentValue is a Double indicating the present value (as a lump sum) that the
series of payments is worth.
PMT(.005, 360, -110000) returns payment amount of 659.51 for a 6 percent loan of
360 months for $110,000 USD.
Mathematical functions
Mathematical functions perform specific calculations. The following are some mathematical functions,
with examples of how to use them.
n Abs(): Returns the absolute value of a number (the number without a sign):
n Abs(-14) returns 14.
n Abs(14) results in 14.
n Fix(): Determines the correct integer for a negative number:
n Fix(-1234.55) results in -1234.
n Int(): Returns the integer of a specific value:
n Int(1234.55) results in 1234.
n Int(-55.1) results in -56.
n Round(): Returns a number rounded to the specified number of decimals:
n Round(14.245, 2) results in 14.24; rounding occurs over 5.
n Round(17.1351, 2) results in 17.14, rounding up to .


Pages:
954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978