# Finding the unknown number

S

#### sierra spiegel

I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what is the future number. The total sum for the listed number is 6 + 1 = 7. Yes the current number is 7. But what is the new number? How do I create a formula do do that?

EggHeadCafe - Software Developer Portal of Choice
VB.NET Event Managment / Logging through Publisher / Subsriber Pattern

S

#### sierra spiegel

Let me clarify:

The sum of all the number +1 = the current answer . How do I do it backward to get the next unknown.

sierra spiegel wrote:

Finding the unknown number
14-Nov-09

I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3

The sum of those number +1 is the answer to the current number, but what is the future number. The total sum for the listed number is 6 + 1 = 7. Yes the current number is 7. But what is the new number? How do I create a formula do do that?

EggHeadCafe - Software Developer Portal of Choice
Read any document (like .doc, .rtf , txt ) in ASP.Net , C#

J

#### Joe User

David Biddulph said:
Past success does not guarantee future performance.

"Guarantee"? Right: probably not.

But the past sequence might reflect a pattern that can be used to determine
the next numbers.

And if there is no discernible pattern, statistical analysis of the
historical sequence might be used to predict the next numbers, within some
degree of confidence.

I think that is the purpose of this assignment or test question.

-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3
[....]
The sum of those number +1 is the answer to the
current [sequence ....]. The total sum for the
listed number is 6 + 1 = 7.

I don't think so. Mind the signs.

----- original message -----

G

#### Gary''s Student

With your data in A1 thru T1, the formula:

=SUM(A1:T1)+1 will display -5

To include future, unknown, values in U1 thru IV1, change the formula to:

=SUM(A1:IV1)+1

R

#### Rick Rothstein

Just pointing out that your first few numbers (at least, I gave up checking
after your third number) do not follow the pattern you say these numbers
have... (-17+9)+1 is not 5, (-17+9+5)+1 is not -9, etc.

--
Rick (MVP - Excel)

in message
news:[email protected]...

M

#### macropod

Hi Joe User,

The fundamental problem is that the number sequence does not match the formula the OP gave. Given that, it'd be a hopless exercise
trying to work out what any subsequent (or previous) number in the sequence should be.

--
Cheers
macropod
[Microsoft MVP - Word]

Joe User said:
David Biddulph said:
Past success does not guarantee future performance.

"Guarantee"? Right: probably not.

But the past sequence might reflect a pattern that can be used to determine the next numbers.

And if there is no discernible pattern, statistical analysis of the historical sequence might be used to predict the next numbers,
within some degree of confidence.

I think that is the purpose of this assignment or test question.

-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3
[....]
The sum of those number +1 is the answer to the
current [sequence ....]. The total sum for the
listed number is 6 + 1 = 7.

I don't think so. Mind the signs.

----- original message -----