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...
Excel VBA Check if a Cell is in a Range
Tutorial: VBA that checks if a cell is in a range, named range, or any kind of range, in Excel. Sec...
Shade Every Other Row in Excel Quickly
Tutorial: How to shade every other row in Excel quickly without using the Table feature. This method...



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.