2.0

Functions
Using Calculations 9-35
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)
Replicate text Replicate: repeats a str for num times Replicate(str, num)
Right text Right: returns characters for str beginning from
the right and proceeding to the left for num
characters
Right(str, num characters)
Round mathematical Round: returns the value of num rounded to the
specified num of decimal places
Round(num, num of decimal
places)
Second time Second: returns the second for a given time Second(time)
Sign mathematical Sign: returns the sign of num. A positive num
returns 1, zero returns 0, and a negative num
returns -1
Sign(num)
Sqrt mathematical Square Root: returns the square root of a
positive number
Sqrt(num)
Sum statistical Sum: returns the total of num1, num2, etc. Sum(num1, num2, ...)
Time time Time: returns the current time as HH:MM:SS
based on the current system clock
Time()
Trim text Trim: removes leading, trailing spaces, and all
other extra spaces from str
Trim(str)
Trunc mathematical Truncate: returns the value of num truncated
down to the specified num of decimal place
Trunc(num, num of decimal
places)
Upper text Upper: converts str to uppercase Upper(str)
Year date Year: returns the year number for a given date Year(date)