excel formulas and function

[carmoo]

i need a formula to add a percentage result to a new value each time the result changes so it would give you a continued total each time.

example to add last week gross to this weeks gross and continue each week.

[#2]

Please provide a specific example of the data you have and the result you need.