#1
|
|||
|
|||
Dynamically updating multiple scenario cashflow Formulas
Hi All,
I have a small problem I would like some help with if possible. Basically what I have is the below (dummy numbers, download picture to see full screen, sorry!): The original cashflow line is what I am working off. I need to produce two alternative rows below this line which do the following: Row 9: Subtract all positive values AFTER the financing date (31 March in this case, this has to be able to change at a later point if required) until the amount subtracted has reached the Threshold amount (Cell B1). I need to ONLY subtract positive amounts and ignore negative amounts. Then once the threshold amount has been matched, I want to add back in the total threshold amount on the closing date (Cell L5, however this may change also so that will need to be taken into account). I have shown this row as I would like to see it output as an example. Row 11: I want to ignore all values until you reach the financing date (31 march). Then ON the financing date, subtract the entire threshold, then proceed to ignore any values until the closing date (31 September) has been reached, then add the full threshold back in ON the closing date. It's the same case above where the financing date and the closing date can change in the future so this would need to update dynamically. I have also shown an example row (row 11) where the inputs I would require are shown. Let me know if any of the above needs clarification, Thanks |
#2
|
||||
|
||||
Hi
please post a sample sheet. Images are nice to look at but utterly useless. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Quote:
Excel Help.xlsx Hi, sorry, please see attached. |
#4
|
||||
|
||||
Please do not cross post without links. Read this to understand why
http://www.excelguru.ca/forums/showt...nario-cashflow http://www.excelforum.com/excel-gene...ml#post4004198 http://www.mrexcel.com/forum/excel-q...low-issue.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
||||
|
||||
I'm sorry, you seem to have all the help you need elsewhere.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
best way to use search/replace wildcards in this scenario? | dylansmith | PowerPoint | 3 | 03-04-2023 08:55 PM |
Using multiple formulas in one (IF, AND and SUM) gives syntax error | markdeniet | Word | 1 | 02-05-2014 05:17 AM |
Multiple Formulas in one Cell one Formula Away From Completion | microsoftnovice | Excel | 2 | 12-05-2012 12:54 PM |
how to transfer multiple excel cells into specific place in word document by formulas | anton | Excel | 1 | 12-20-2011 03:56 AM |
How to transfer multiple cells from excel to word by formulas | justziggy | Word | 5 | 05-23-2009 02:33 AM |