Forum Discussion

Aynur1990's avatar
Aynur1990
Copper Contributor
Oct 18, 2022

I do not know which info I need to add the formula

Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. The cost of the ring type should be an exact match. Use appropriate relative and absolute cell references Name...
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 18, 2022

Aynur1990 

=VLOOKUP(B2,$G$10:$H$13,2,FALSE)

You can try this formula.

 

  • Aynur1990's avatar
    Aynur1990
    Copper Contributor
    Oct 18, 2022
    Great thanks.
    The second question:
    Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references. Ensure the result is a positive number.
    Inland Jewelers
    Date

    Name Ring Type Cost Personalized Total Years Monthly Payment
    Dodson Silver $400.00 Yes 1
    Jones Gold $550.00 Yes 1
    Clarke Titanium $700.00 No 2
    Ranger Platinum $750.00 No 3
    McKinley Platinum $750.00 Yes 3
    Broadnax Gold $550.00 No 2
    Burch Titanium $700.00 Yes 3
    Totals


    Ring Type Cost
    Silver $400.00
    Gold $550.00
    Titanium $700.00
    Platinum $750.00

    Personalizing Surcharge 5%
    Interest Rate 3%
    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      Oct 18, 2022

      Aynur1990 

      =VLOOKUP(B2,$G$10:$H$13,2,FALSE)*IF(D2="Yes",1.05,1)/(F2*12)

      Does this return your expected result?

Resources