View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay
 
Posts: n/a
Default Which function to use?

It works great. Can you explain why mul 12, subs the princ., then
div. By 66. Is this higher math ??


High-school math, tops.

Start with a problem statement:

Total = January amount
+ January amount + increment
+ January amount + 2 * increment
+ ....
+ January amount + 11 * increment

and solve for "increment".

This approach assumes that you want the monthly increases to be linear.
Other approaches are possible if the monthly increases are supposed to
follow a different rule.


So I guess it can not be done with a function.


There are lots of approaches. I'm sure some would use a function. If
there's some reason why a function is required, please explain.