 |
|
Matrices store expressions in a two-dimensional matrix.
The search values in the x-direction (horizontal) and y-direction (vertical) are formed with the Is key term.
The expressions in the fields of the matrix are expressions.
In this example, the matrix value for x = "C" and y = 3 is the expression Delivery + 3.50, which is in fact assuming a delivery price of 2 a value of 5.50.
The return value of a matrix is of type Variant.
If the search for x and y-value does not yield a hit (e.g. for x="K"and y=3), then the value of the expression "No hit" is returned, in this case NoValue.
If the search for x and y value returns an empty cell, the value of the expression "default value" is returned, in this case an asterisk.
Contents
Index
Previous
Next