|The previous spreadsheet
shows us various possible monthly payments.
Yet, if there is an exact amount that user cannot pay more than, then
the Goal Seek Command is used to determine the maximum amount the user can borrow. The Goal Seek Command allows the user to
set the desired output so that the required inputs can be displayed. This way, the maximum amount of loan the
user can take out and still make a specific payment, is shown, along with the
interest payment. Only one input can
be changed by the user at a time.