Thursday, 2 January 2020

Excel Scenario Manager

I can't figure out how to create a "what-if" summary by using 2 cells for each scenario. For example, there is a $1,000 loan with payments of $50,$100,$150 and a $2000 loan with payments of $100,$150,$250, the interest rate is 10%.How can I use the scenario manager to create a summary showing different payback lengths and total amount paid?

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...