contestada

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 :

aencabo
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)

Otras preguntas