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.

=GROWTHX(exponent, basic, constant)

=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 is the reverse of GROWTHX. That is, it returns the power used in the calculation of y.

=GROWTHY(y, basic, constant)

=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