2.0

Functions
Using Calculations 9-33
Functions — Quick Reference
See “Usage Conventions” on page 9-8 for information on how to
interpret the examples in the following table. A brief description and
usage of each function is listed.
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,
etc.
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, etc.
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)