'Declaration
 
Public Function Growth( _
   ByVal knowY As Object, _
   Optional ByVal knowX As Object, _
   Optional ByVal newX As Object, _
   Optional ByVal constant As Object, _
   Optional ByVal worksheet As IWorksheet, _
   Optional ByVal contextRow As Integer, _
   Optional ByVal contextColumn As Integer _
) As Object

'Usage
 
Dim instance As WorksheetFunction
Dim knowY As Object
Dim knowX As Object
Dim newX As Object
Dim constant As Object
Dim worksheet As IWorksheet
Dim contextRow As Integer
Dim contextColumn As Integer
Dim value As Object
 
value = instance.Growth(knowY, knowX, newX, constant, worksheet, contextRow, contextColumn)

public object Growth( 
   object knowY,
   object knowX,
   object newX,
   object constant,
   IWorksheet worksheet,
   int contextRow,
   int contextColumn
)

Parameters

knowY

The set of y-values you already know in the relationship y = b*m^x.

knowX

An optional set of x-values that you may already know in the relationship y = b*m^x.

newX

New x-values for which you want GROWTH to return corresponding y-values.

constant

A logical value specifying whether to force the constant b to equal 1.

worksheet

The context worksheet to calculate.

contextRow

The context row to calculate.

contextColumn

The context column to calculate.

Reference

WorksheetFunction Class
WorksheetFunction Members