Date. perform function every 12 months

qinyu

New Member
Joined
Dec 21, 2005
Messages
1
Hi,

i have a row of dates starting with 3/1/2000 (increasing every month) and ends at 3/1/2005.

i need to increase the price of A every 2 yrs by 5%, and the price of B every 3 yrs by 8%. between the above dates.

how can i create a function to do that. and to change the price increase from 2 yrs to 4 yrs by changing one cell (the no. of years)

thanks :biggrin:
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,251
Members
412,709
Latest member
Rishu
Top