View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ali ali is offline
external usenet poster
 
Posts: 5
Default an iterative calculation -- sort of

hello

i have values

10
15
20
30
40

....from which i want to subtract 30, starting with the first number and
iterate through my list until i've completed the sum. so for example i would
eliminte the 10, 15 and part of of the 20 to be left with:

0
0
15
30
40

This is the first part of a bigger problem and ideally i'd like to attempt
it without any vba. is this even possible ??


thanks
ali