The variable is the interest rate, so reference cell B3 next to Column input cell:. Click OK. The monthly payments based on interest rates between 4% and 10% will automatically populate in cells B10 ...