Each function uses different parameters, but there are some features that all of the functions have in common. Unless otherwise indicated, each parameter can be specified as follows:
A literal value enclosed in double quotes; for example, PL("2", "4000-000", "2/15/09", "2/21/09").
A cell reference to a cell that has a value specified. For example, CompeatPL($C$3, C5, $C$5, $c$6).
A combination of literal values and cell pointers. For example, CompeatPL($C$3, "4000-000", $C$5, "12/31/09").
Note: If specifying a literal for the parameter in the function, enclose the value in double quotes.
The entity number and account code parameter value can be any of the following:
A single value. For example, a single account number such as "4500-000."
Several values. For example, three account numbers such as "4500-000, 4600-000, 4700-000."
A range of values, with the start and end values separated by two dots (..).
For example, "4500-000..4800-000" or "45*..48**."
An asterisk (*) wildcard value. For example, "45*" will specify all accounts starting with 45, such as 4500, 4501, 4539, and so on.
A combination of any of the above. For example, "45*..4800-999, 4900-300."