GROWTHX and GROWTHY

These functions can be used to generate the x and y values required by Microsoft Excel's GROWTH function.

GROWTHX

Returns the value of y, where y is the result of raising a value to a specified power and then multiplying by a second value.

Syntax

=GROWTHX(exponent, base, constant)

Example

=GROWTHX(2,3,4) returns 36.

That is, 3 raised to the power of 2, multiplied by 4: 
(3^2)=9
9x4=36
y=36

GROWTHY

GROWTHY is the reverse of GROWTHX. That is, it returns the power used in the calculation of y.

Syntax

=GROWTHY(y, base, constant)

Example

=GROWTHY(36,3,4) returns 2.

That is, 3 raised to the power of y, multiplied by 4=36: 
(3^y)=9
9x4=36
y=2