Parameter types

Revision as of 19:25, 2 February 2007 by Max (talk | contribs)

This explains the syntax used for precise definition of what kinds of parameters a function expects, and what it does with them. The syntax and options are the same as the parameter qualifier syntax used for defining parameters for User-defined Functions:

  • X: Numeric: Parameter X must be a number or array of numbers. INF, -INF, and NAN qualify as numbers in this case.
  • T: Text: Parameter T should be a text or array of texts.
  • T: Text Coerce: If T is a number, it will be coerced to become at Text, i.e. converted into a text, using the Number Format specified for this variable (or default Number specified). For example, if the Number Format is set to Date, it will become a text containing the date.
  • X: Optional: The parameter X is optional.
  • X = 99: X is optional and defaults to 99


and a lot more.

Comments


You are not allowed to post comments.