Excel Forum



Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changed


See how to create an Amortization table that can handle variable year inputs. See the functions: PMT, IF, and ROWS.





Got a Question? Ask it Here in the Forum.