Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Shade Every Other Row in Excel Quickly
Tutorial: How to shade every other row in Excel quickly without using the Table feature. This method...
Automatically Run a Macro When a Workbook is Opened
Tutorial: How to make a macro run automatically after a workbook is opened and before anything els...



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.