Functions
Using Calculations 213
Functions — Quick Reference
See “Usage Conventions” on page 209 for information on how to
interpret the examples in the following table. Or, refer to online help for
an example of each function. The following table lists a brief description
and usage of each function.
Function Type Description Usage Example
Abs
mathematical Absolute Value: returns the value of num Abs(num)
Avg
statistical Average: returns the average for num1, num2,
and so forth
Avg(num1, num2, ...)
Date
date Date: returns the current date as MM/DD/YY
based on the current system date
Date()
DayName
date DayName: returns the name of the day of the
week for a given date
DayName(date)
DayOfMonth
date DayOfMonth: returns the number for the day of
the month for a given date
DayOfMonth(date)
DayOfWeek
date DayOfWeek: returns the number for the day of
the week for a given date. Sunday returns 1,
Monday returns 2, and so forth
DayOfWeek(date)
DayOfYear
date DayOfYear: returns the number for the day of
the year for a given date
DayOfYear(date)
Exp
mathematical Exponentiation: returns the value of the
constant e, the base of natural logarithms
(approximately 2.71828) to the power of
num; inverse of ln function.
Exp(num)
FV
financial Future Value: returns the future value of an
investment given a payment num, interest rate
num, and num of periods
FV(payment num, rate num, num
of periods)
Hour
time Hour: returns the hour for a given time Hour(time)
If
logical If: if the log exp is true, the true exp is executed;
otherwise, the false exp is executed
If(log exp, true exp, false exp)
Int
mathematical Integer: returns the integer portion or whole
number of num
Int(num)
Left
text Left: returns the characters for str beginning
from the left and proceeding to the right for
num characters
Left(str, num)
Length
text Length: returns the number of characters in str Length(str)