WorksheetFunction Class Members
In This Topic
The following tables list the members exposed by WorksheetFunction.
Public Methods
| | Name | Description |
|---|
  | CreateExpression | Creates an expression from the specified primitive value. |
| Growth | Calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values. |
| Index | Gets a value or the reference to a value from within a table or range. |
| Trend | Gets values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's. Gets the y-values along that line for the array of new_x's that you specify. |
TopSee Also