View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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