Functions
14 Using Calculations
ln mathematical Natural Logarithm: returns the natural
logarithm (base
e
— approximately 2.71828)
of num; inverse of Exp function of num
ln(num)
Log mathematical Base 10 Logarithm: returns the base 10
logarithm of num
Log(num)
Lower text Lower: converts the str to lowercase Lower(str)
Max statistical Maximum: returns the maximum (highest)
value for num1, num2, and so forth
Max(num1, num2, ...)
Middle text Middle: returns the characters for str beginning
at start position num for num of characters
Middle(str, start position num,
num of characters)
Min statistical Minimum: returns the minimum (lowest) value
for num1, num2, and so forth
Min(num1, num2, ...)
Minute time Minute: returns the minute for a given time Minute(time)
Mod mathematical Modulus: returns the remainder of the dividend
num divided by the divisor num
Mod(dividend num, divisor
num)
Month date Month: returns the number of the month for a
given date
Month(date)
MonthName date MonthName: returns the number of the month
for a given date
MonthName(date)
Pi mathematical Pi: returns the value of Pi (approximately
3.14159265)
Pi()
PMT financial Payment: returns the payment required given a
principal num, interest rate num, and num of
periods
PMT(principal num, interest rate
num, num of periods)
Position text Position: returns the position in the source str of
the find str beginning at start position num
Position(source str, find str, start
position num)
Proper text Proper Case: converts the first letter of each
word in str to uppercase and the rest of the
word to lowercase.
Proper(str)
PV financial Present Value: returns the present value of an
investment given a payment num, interest rate
num, and num of periods
PV(payment num, interest rate
num, num of periods)
Record Count database Record Count: returns the number of records in
the current database.
RecordCount()
Replace text Replace: replaces the source str beginning at
start position num for num of characters with
the replacement str
Replace(source str, start position
num, num of characters,
replacement str)