How to determine the formula?
Oops. Try this instead.
Function Fx(n, k)
' n Number
' k Number of iterations
Fx = (2 * k + Sqr(n) - 2) ^ 2
End Function
--
Dana DeLouis
Windows XP & Excel 2007
"Gary''s Student" wrote in message
...
Try this small UDF:
Function eric(v As Variant, n As Integer) As Double
Dim tw As Double
tw = 2
eric = v
For i = 1 To n
eric = (eric ^ 0.5 + tw) ^ tw
Next
End Function
So
=eric(3,2) displays
32.85640646
--
Gary''s Student - gsnu200745
"Eric" wrote:
Does anyone have any suggestions on how to determine the formula for
following series?
The 1 st number is n
Ther 2 nd number is Power(Sqrt(n)+2,2),
The 3 rd number is Power(Sqrt(Power(Sqrt(n)+2,2))+2,2), then substitute
the
previous value into the same formula format.
The 4 th number is Power(Sqrt(Power(Sqrt(Power(Sqrt(n)+2,2))+2,2))+2, 2),
The 5 th number is Power(Sqrt([Previous value])+2,2),
Does anyone have any suggestions on how to determine this repeated
structure
in a formula? therefore, if the any number is given, then I can determine
the
result directly rather than calculate a list of values in order to get
the
result.
Thank in advance for any suggestions
Eric
|