| MiniString | A string with a maximum length of 30 characters |
| Integer | An integer (whole number). If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
| Large Integer | An (potentially) large integer |
| Integer (Optional) | Either an Integer (whole number) or the variable can be omitted. v |
| Real Integer | An integer (whole number). If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
| Float | A floating point (ie not an integer) number.If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
| Float (Optional) | Either a Float number (ie not an integer), or the variable can be omitted. If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
| String | A string (text, characters) of maximum length 255 characters. |
| String (Optional) | Either a String (ie text, characters) or the variable can be omitted. |
| Boolean | A variable that only has two states TRUE or FALSE. |
| Boolean (Optional) | An optional variable that only has two states TRUE or FALSE. |
| Date | A date number in Excels own system of date numbers, or can also be a decimal year (eg 2001.5, 2002.75). If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
| Date (Optional) | A date number in Excels own system of date numbers, or can also be a decimal year (eg 2001.5, 2002.75). If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
| TimePeriod Start | The start of a timeperiod, expressed as a Date |
| TimePeriod Base | The base or length of the timeperiod in exact months. Can also be the end of a timeperiod as a Date. |
| TimePeriod BaseYrs Compatibility | The base of the timeperiod in fractions of a year, provided that it corresponds to an exact number of months. |
| Cell or Range Reference | A reference to another cell or range of cell. |
| Range Of Integers | A range (either one or range of cells) consisting all of type Integer. |
| Range Of Floats (Optional) | A range (either one or range of cells) consisting all of type Float, but which is optional. |
| Range Of Integers (Optional) | A range (either one or range of cells) consisting all of type Integer, but which is optional. |
| Range Of Booleans | A range (either one or range of cells) consisting all of type Boolean |
| Range of Floats (numbers) | A range (either one or range of cells) consisting all of type Float. |
| Range Of Strings | A range (either one or range of cells) consisting all of type String. |
| Range Of MiniStrings | A range (either one or range of cells) consisting all of type Integer. |
| Range Of Dates (Optional) | A range (either one or range of cells) consisting all of type Date (optional) |
| Range Of Dates | A range (either one or range of cells) consisting all of type Date. |
| Annual Sequence | A range (either one or range of cells) consisting of annual sequence numbers in the format mm.dd such as 01.31 (for 1st January) or 12.25 (for December 25th) |
| Annual Sequence (Optional) | Either an Annual Sequence (series of sequence numbers in the format mm.dd) or an Integer to select a fixed option |
| Any (Optional) | Any data type, number, boolean, string or error type (eg @ERR) |
| Any | Any data type, number, boolean, string or error type (eg @ERR) |
| Poly | Polymorphic: String, Number or Date |
| Poly (Optional) | Polymorphic: String, Number or Date |
| Range of Poly (Optional) | Polymorphic: String, Number or Date |
| Range of Poly | Polymorphic: String, Number or Date |
| Range of NumOrDates | A range of numbers or dates. If the each individual number is greater than 25000 (11 June 1968) AND less than 100000 (14 Oct 2173), it is assumed to be a date. |
| NumOrDate (Optional) | A number or a date. If the number is greater than 25000 (11 June 1968) AND less than 100000 (14 Oct 2173), it is assumed to be a date. If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
| Number (Optional) | A number If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). |
Any comments on this documentation? Send us your suggestions below.
