Insert a function in cell G5 to calculate the first student\'s monthly payment,
ID: 3587697 • Letter: I
Question
Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references.
AutoSave DominicFrasca exploring e02 grader_h1.xlsx - Excel File Insert Draw Page Layout Formulas Data Review View w Tell me what you want to do AutoSum . A Fill Calibri Wrap Text Conditional Format as Cell Formatting Table Styles Sort & Find& Filter Select Merge Insert Delete Format Clear Clipboard Font Alignment Cells H13 Inland Jewelers Name Tpe Cast PersonalizedTtYear 5 Codur 6 lones T Clarke 8 Ranger 9 McKirley Platinum 10 Breacnax 11 Burch 2 Totals il5 400.00 Ye Gold$ 550.C0 Yes 700.00 No Platinum 750.CO No 5.c0 Yes S50.C0 No litanium S ·OU.CO Yes $ 42000 577.50 s 700on 75D.o0 TR7 1 535,57) 1548.91 2 530.0 3 $21.8 2 1$23.641 :S21.3 Gold 6 Siver 17 Gold 400.00 S 550.00 5 700.00 5 750.00 Titanium Painm Personalizirc 3% ClassRing Reacy 1]- + 70% Type here to search 3:26 PM 10/6/2017Explanation / Answer
Worksheets("data").Range("G5").Formula = "=$E5/($F5*12)"
To write formula first identify the cell in which you want to write formula.
Then to calculate monthly payment we need to convert yesrs to months, So ($F5*12)
After getting total months divide it by monthly total amount whichis $E5.