Weighted Averages?
As the first number, use
=200/SUM(1.1^(ROW(A1:A10)-1))
Entered using Ctrl-Shift-Enter
HTH,
Bernie
"Kevin" wrote in message
...
Assume that 10 numbers = 200
What formula would I use to average (weight) these 10 numbers so that the
2nd number is 10% greater than the 1st, the 3rd number is 10% greater than
the 2nd, the 4th number is 10% greater than the 3rd, etc . . . and the
total
of 10 numbers will equal 200?
Im sure someone knows the answer!
Thanx in advance
Kevin
--
Kevin
|