|
|
|
|
|
|
|
|
|
|
|
|
|
|
| When a Table control contains numeric data, it may be useful to get the total of a column or count the number of elements...... |
|
|
|
|
|
|
|
| Returns the numeric value of a character string. This feature enables you to perform numeric calculations on strings. |
|
|
|
|
|
|
|
| Returns the numeric value of a character string. This feature enables you to perform numeric calculations on strings. |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item...... |
|
|
|
|
|
|
|
| Calculates the cotangent of an angle. |
|
|
|
|
|
|
|
| Calculates the cosine of an angle. |
|
|
|
|
|
|
|
| Calculates the tangent of an angle. |
|
|
|
|
|
|
|
| Calculates the transposed matrix. |
|
|
|
|
|
|
|
| Calculates the hue of a color. |
|
|
|
|
|
|
|
| Calculates the saturation of a color. |
|
|
|
|
|
|
|
| Calculates the lightness of a color. |
|
|
|
|
|
|
|
| Calculates the sum of the array elements. |
|
|
|
|
|
|
|
| Calculates the sum of the array elements. |
|
|
|
|
|
|
|
| Calculates the sum for a series of values. |
|
|
|
|
|
|
|
| Calculates the variance for a series of values. |
|
|
|
|
|
|
|
| Calculates the inverse of a square matrix. |
|
|
|
|
|
|
|
| Loads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer). |
|
|
|
|
|
|
|
| The columns are used to display information in a Table control...... |
|
|
|
|
|
|
|
| Loads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer). |
|
|
|
|
|
|
|
| Changes the color of a section in a Sunburst chart. |
|
|
|
|
|
|
|
| Changes the color of a section in a Sunburst chart. |
|
|
|
|
|
|
|
| Calculates the number of days between two dates. |
|
|
|
|
|
|
|
| Calculates the difference between two dates and times. |
|
|
|
|
|
|
|
| Calculates the distance of an itinerary in a Map control. |
|
|
|
|
|
|
|
| Calculates the distance of an itinerary in a Map control. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|