In cell G5, enter a formula to calculate the total amount due for the first client based on the annual total and the number of years in the contract. Copy the three formulas in columns C, G, and E down their respective columns.

Respuesta :

The answers for your question are: 
1) =E5*F5 (copy to cells G6:G13) 

2) =VLOOKUP(B5,Membership,3,FALSE) 

3) =PMT(B$23/B$24,F5*B$24,-I5)
Q&A Platform for Education
Platform Explore for Education