| AND
|
Enter several conditions and the AND function tests to see if all
conditions are met.
|
| BLANK
|
When the result is text, list, time period, or date-formatted the result can be set to be BLANK. |
| COMPARE
|
Compares text values; result is 0 if they match, 1 or -1 if not matched.
|
| FIRSTNONBLANK
|
Shows the first non-blank text, list or date cell and uses the mapping to determine where to post the result. |
| IF THEN ELSE
|
Conditional formula.
|
| IF...ISNOTBLANK
|
Test to see if a date, text, time period, or list-formatted cell is not blank.
|
| IF…ISBLANK
|
Tests whether a date, text, time period or list-formatted cell is blank.
|
| IF...AND
|
Tests whether 2 or more conditions are met.
|
| IF...NOT
|
Tests whether condition is not true.
|
| IF...OR
|
Tests if any of 2 or more conditions is met.
|
| ISANCESTOR
|
Tests whether a specified list item is an ancestor of the second specified list item or whether a specified time period is an ancestor of a second specified time period (result is Boolean-formatted). |
| ISBLANK
|
Tests whether an item is blank (the item must be date, text, list, or time period-formatted and the result is Boolean-formatted). |
| ISFIRSTOCCURRENCE
|
Tests if a value in the source (first parameter) is the first occurrence of that value within the source (result is Boolean-formatted). |
| ISNOTBLANK
|
Tests whether an item is not blank (the item must be date, text, list, or time period-formatted and the result is Boolean-formatted) |
| LASTNONBLANK
|
Shows the last non-blank text, list or date cell and uses the mapping to determine where to post the result. |
| LOOKUP
|
Looks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item. |
| NOT
|
Tests to see if a condition is not met (result is Boolean-formatted).
|
| OR
|
Tests to see if any
of two or more conditions is met.
|
| SELECT
|
Selects a specific item from one or more of the hierarchy lists.
|
| SELECT & LOOKUP
|
Selects a specific item from one or more of the hierarchy lists, then looks up a value based on matching that selection.
|
| SUM
|
Sums values based on a list-formatted or time period-formatted line item or property in the source that matches a dimension in the target. |
| SUM & LOOKUP
|
First it sums based on a list-formatted line item or property in the source, then looks up a value from a source module using one or more mappings.
|
| SUM & SELECT
|
First it selects a specific item from one or more of the hierarchy lists, then it sums values based on a list-formatted line item or property in the source that matches a dimension in the target.
|
| TEXT
|
Converts a numeric value to text.
|
