Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 3 input cells (data will change based on user input) :
A1 300 (value) "start rate" A2 10 (percent) "decline" A2 feb-07 (date as month and year) "start date" I need to populate cells based on the "start date", "decline", "start rate". Example output: jan07 0 feb07 300 mar07 290 arp07 280 may07 270 jun07 260 jul07 250 aug07 240 sep07 230 oct07 220 nov07 210 dec07 200 Another example is the start date could change to may-07 and the output would start the cacluation on May07 through dec07. So may07 will be 300, jun07 is 290, jul07 is 280, aug07 is 270, ....dec07 is 230. I am OK with the math but I am having problems getting the right functions/code for the startdate and the calculations after that. thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Date calculation | Excel Worksheet Functions | |||
Time Calculation For A Timesheet To Include Lunch | Excel Worksheet Functions | |||
Please help with time calculation | Excel Discussion (Misc queries) | |||
Help on automatically ending a calculation | Excel Worksheet Functions |