View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sierra spiegel sierra spiegel is offline
external usenet poster
 
Posts: 18
Default Finding the unknown number

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
http://www.eggheadcafe.com/tutorials...anagment-.aspx