PS....

On Sep 29, 4:18 pm, joeu2004 wrote:
In the first example, that would result in a negative value
because 2%*10000 - 1000 is 200 - 1000. So I ass-u-me
you mean that you want the value __increased__ by the
interest rate; hence A1*(1+B1).

Well, there is nothing wrong with a negative result. You might sell
something at a loss.

The real reason why I ass-u-me that A1*(1+B1) is what you want is
because I ass-u-me that when you say "interest rate", you really mean
the cumulative growth rate; for example, a 401(k) account that has
increased by 2% over the life of the investment.