Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here is the situation:
Column A is a unique ID number Column B is a $ amount Column C to Column J has 7 monthly $ amounts I would like to determine in how many months/days it would take for the sum of the monthly amounts in Column C to J is equal to the $ amount in Column B. (i.e. all of column C, D, E is 3 months) If it is not to difficult to figure out days based on 30 day months and percentages of the amount in given column. (i.e. all of column C half of column D is 45 days) Any advice and help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Payback Period | Excel Discussion (Misc queries) | |||
Payback Period | Excel Discussion (Misc queries) | |||
How to create data tables and is there a payback period function | Excel Worksheet Functions | |||
drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
Sum of row until you reach a certain amount | Excel Discussion (Misc queries) |