Data tables using variables
 

Hello anyone

I have been trying to work through an Excel Advanced book, for work
purposes. Upon entering data regarding loan estimates the monthly repayment
formulae works ( insert function PMT) but when trying to work just one
variable into the equation by redoing table next to the original with year
variables : Data, tables, column input cell. selecting form original table
then ok. The varied repayments are the same as original