Anna;398162 Wrote:
Thank you for your fast answer.

What I am trying to do is basically to be able to have regressing
percentage
against my increasing cost.

My cost is in a column sorted from lowest to highest . I want to be
able to
add on the next column a formula with which with one click to apply
this
formula to all the cells in the same column (as we do with all
formulas).

So,,,if at the starting point of $0.01cost I have in the formula added
20%
[sum= A1*1.20], at the end of my cost list to have only 2% added [
sum=A12510*1.02].


Sample of what I am trying to accomplish:

$50 x 12%
$ 51 x 11.99%
$ 52 x 11.98%
$ 53 x 11.97% and so on...


How do I do it?
Thanks again for your help!




Say you have your costs currently in A2, downwards...

Use an input cell for starting rate of 12% or 0.012(e.g. Cell D1) and
another input cell for the change in rate. of 0.01% or 0.0001 (e.g. Cell
E1)... then use formula in B2, copied down..

=A2*($D$1-($E$1*(ROW($A1)-1)))

You can change your input values as needed to automatically update
formula results...


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111150