View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How to determine the formula?

An example might help because I am confused by then substitute the
previous value into the same formula format.

n=2
first = 3
second =
etc
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
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