Referring to the worksheet shown below: What formula should be entered into the worksheet to calculate the monthly payment in cell F6 =PMT(VLOOKUP(C6,\$A\$18:\$C\$20,2)/12,C6*12,-E6) =PMT(VLOOKUP(C6,\$A\$18:\$C\$20,2/12),C6*12,-E6) =PMT(VLOOKUP(C6,\$A \$18:\$C\$20,2)/12,C6,-E6) =PMT(VLOOKUP(C6,\$A\$18:\$C\$20,2),C6,-E6) None of the above = =PMT(VLOOKUP(C6,\$A\$18:\$C\$20,2),C6*12,-E6)