View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Finding the unknown number

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)


"sierra spiegel" wrote in message
...
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?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Read any document (like .doc, .rtf , txt ) in ASP.Net , C#
http://www.eggheadcafe.com/tutorials...ent-like-.aspx