Excel-Like Constants

The following Excel-like constants have been identified and defined to the parser.

Table 5 Excel-Like Constants

CONSTANT	COMMENTS
TRUE	Returns the integer value 1.
FALSE	Returns the integer value 0.
TODAY	Returns the current date.
NOW	Return the current date and time.

As with Excel functions, these functions can be nested to any level. Also, all expressions can include parentheses to force expression evaluation order.

The following is an example of nested functions, although granted it is not a very realistic example.

IF(SUM(salestotal1,salestotal2)<2000,TRUE,IF(salestotal>2000,SUM(salescount,salestotal),salestotal*.5))

It should also be noted that the following two feature extends the capabilities of what Excel supports.

Functions that take a variable number of arguments (ex. OR), are not limited on the number of arguments they can take. Excel has a limitation.