formula for adding x periods/mo add 11% to each
 

070403 formula for adding x periods/mo add 11% to each

hi, trying to find progress on a number: 100 starting apr 1, add 11% each 4
business days.
trying to get a separate progress for each month.

have figured business days as: (Jan-Dec)
22 20 22 21 23 22 23 22 21 22 21 22

days /mo: 21.75 days /yr: 261 reps /yr: 65.25 reps /mo:
5.4375

guessing start 1st col with months, next with start figure in apr: 100
column: monthly totals (times 5.4375 reps..)
column: running total

-----------
don't know if this is similar to old math trick start with add 1 penny on
1st day of month, double that every day for 30 days equals...

formula for adding x periods/mo add 11% to each
 

trying: =(D10*11%)+D10 and dragging across 65 cells, neater way?



"nastech" wrote:

070403 formula for adding x periods/mo add 11% to each

hi, trying to find progress on a number: 100 starting apr 1, add 11% each 4
business days.
trying to get a separate progress for each month.

have figured business days as: (Jan-Dec)
22 20 22 21 23 22 23 22 21 22 21 22

days /mo: 21.75 days /yr: 261 reps /yr: 65.25 reps /mo:
5.4375

guessing start 1st col with months, next with start figure in apr: 100
column: monthly totals (times 5.4375 reps..)
column: running total

-----------
don't know if this is similar to old math trick start with add 1 penny on
1st day of month, double that every day for 30 days equals...

formula for adding x periods/mo add 11% to each
 

It appears you are on the right path if you are really interested you could
enter in the formula in say D10 as =D10*1.11 highlight across the range and
click CTRL+D and it will fill down the rest of the series. That's not much
quicker but may prove handy when you have a bigger set of numbers.

"nastech" wrote:

trying: =(D10*11%)+D10 and dragging across 65 cells, neater way?



"nastech" wrote:

070403 formula for adding x periods/mo add 11% to each

hi, trying to find progress on a number: 100 starting apr 1, add 11% each 4
business days.
trying to get a separate progress for each month.

have figured business days as: (Jan-Dec)
22 20 22 21 23 22 23 22 21 22 21 22

days /mo: 21.75 days /yr: 261 reps /yr: 65.25 reps /mo:
5.4375

guessing start 1st col with months, next with start figure in apr: 100
column: monthly totals (times 5.4375 reps..)
column: running total

-----------
don't know if this is similar to old math trick start with add 1 penny on
1st day of month, double that every day for 30 days equals...