Forum Discussion
Aynur1990
Oct 18, 2022Copper Contributor
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...
OliverScheurich
Oct 18, 2022Gold Contributor
- Aynur1990Oct 18, 2022Copper ContributorGreat 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%- OliverScheurichOct 18, 2022Gold Contributor
=VLOOKUP(B2,$G$10:$H$13,2,FALSE)*IF(D2="Yes",1.05,1)/(F2*12)Does this return your expected result?