Descriptive Formulas
The Descriptive Formulas function generates values from the Base range using the Formula(s) specified and places the results as a table at the Placement.
Settings | |
|---|---|
Formula (up to 6) | The formula to apply to every column (or row depending on Direction) in the Base range. This can be any formula supported by Excel with # used in place of the cell reference for the column (or row). For example, to count all the values in each column that are greater than 0, set Formula to =COUNTIF(#,”>0”) |
Add Labels | If set to Yes and the Direction is Down or None, labels appear to the left of the data. If the Direction is Across, labels appear above the data. Labels are derived from the formula name. |
Place Formula | If set to Yes, the formulas are left in the Placement. If set to No, only the values appear in the Placement. |
Example
Calculate the average of the absolute deviations of temperature.
Base | |
|---|---|
Cell | $C$3:$E$3 |
Direction | Down |
End | All cells are empty |
Placement | |
|---|---|
Cell | $C$13 |
Setting | Value |
|---|---|
Formula | =AveDev(#) |
Formula | |
Formula | |
Formula | |
Formula | |
Formula | |
Add Labels | No |
Place Formula | No |