Functions
Using Calculations #
Functions — Quick Reference
See “Usage Conventions” on page 8-9 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)