Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hello, I've been reading through the user forum's and I've noticed that people have come up with elaborate Macros to automatically calculate the discounted payback. In looking at Jaxworks, I've found one possible solution. It's almost working for me, but not when I start playing around with my cash flows. The formula is: =INDEX((Year-CumulativeDiscountedCashFlow/DiscountedCashFlow),1,SUM(IF(CumulativeNetCashFlow <=0,1,0))+1) All of the words such as Year, CumulativeDiscountedCashFlow, etc. refer to rows of values. For example, Year = row of cells with years 0 to 5. Is there a glitch in this formula? Has anyone ever made it work before? Any other suggestions? Jordan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I stop excel from automatically making hyperlinks | Excel Discussion (Misc queries) | |||
Deleting things automatically in Excel | Excel Discussion (Misc queries) | |||
Can you automatically insert next sequential number in an excel fo | Excel Discussion (Misc queries) | |||
The Excel cells are not automatically calc. existing formula. | Excel Worksheet Functions | |||
program excel worksheet to automatically not print blank rows | Excel Worksheet Functions |