Excel formula for finding next number in a given sequence?

[Rod]

I would like to know if there is a formula that can determine what number
comes next in a sequence of given numbers.

[protonLeah]

Unless you know before hand whether the sequence is Arithmetic or Geometric, you may have a very tough time writing a macro to figure it out by testing data in cells. You could assume it to be Arithmetic and take the difference between the last two cells and add it to the value in the last cell to get the next value, but...
--------------------
Ben

[doco]

Ummm... N + 1?

How about more information...

doco

"Rod" <[email protected]> wrote in message
news:[email protected]...
>I would like to know if there is a formula that can determine what number
> comes next in a sequence of given numbers.

[Jerry W. Lewis]

You might find
http://www.research.att.com/~njas/sequences/
useful. If that is not what you are asking, then reply back with more
complete description.

Jerry

"Rod" wrote:

> I would like to know if there is a formula that can determine what number
> comes next in a sequence of given numbers.