Couldn't be more explicit since I don't understand the problem well enough.

We had set a price for our house before the market tanked in '07.

If we were to attempt to sell the house now (just as an example) I'm curious what the price would be simply reflecting the cumulative increase in price that the yearly general national inflation rate would have.

So if the price in '07 was $100 and the inflation rate for the years '08 through '13 was (hypothetically) 1, 2, 1, 3, 4, 2.5 then $100 in '07 would equal $? in /13?



Mark

=100*1.01*1.02*1.01*1.03*1.04*1.025=114.245

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I was expecting some obtuse (to me) formula and am relieved to be reminded of such a simple and straightforward solution.

Thanks,

Mark

If you really want a formula, the PRODUCT function would do. You just need to enter the numbers in different cells

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Given the choice (thanks) I went back to your initial (simple) suggestion.

One problem however--1 of the years has negative inflation. When that value is included in the string it turns the product into a negative number instead of reducing the preceding cumulative total by that year's negative inflation?

Say that negative inflation is 3%. Then use 0.97 (1.00-0,03*1) instead of a greater than one number

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

You lost me

Peco, I realize that the use of hyphens has almost died out, but sometimes they're really helpful. Translation, markg: Put it this way: Inflation and interest are measured in percentages. $1000 in 2013, after 2% interest for a year, is worth not 2% times $1000 but (1+2%) times $1000, ie 1.02 times $1000. A negative percentage is calculated the same way: After losing 3% of its value, $1000 is worth not -3% * $1000 but (1-3%) * $1000, or 0.97 * $1000.

Okay, now I understand.

Thanks

Sorry about that. Don't forget English is not my mother tongue

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

It isn't? Really? I don't think I realized that; you're usually perfectly fluent. The hyphen thing is about what I would have expected from an Anglophone—I mean, lots of English speakers omit them, too.. What's your maternal language?

French+Dutch

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post