Function |
Purpose |
Crosstab.Cells.Max() or Crosstab.Cells.Min() |
Returns the largest or smallest value in the entire crosstab. |
Crosstab.Cells.Avg() |
Returns the average value for the entire crosstab. |
Crosstab.Col$() |
Returns the description of the column or the row for the current cell.
|
Crosstab.Value() |
Returns the content of the cell (as a number). |
Total() |
You can use this function for calculations across all cells. Otherwise, calculations are always made across all values that affect the respective cell. |
Join$() |
Returns a collection of strings, separated by a particular character. |