Forum Discussion
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 | Ring Type | Cost | Personalized | Total | Years | Monthly Payment | |
| Dodson | Silver | Yes | 1 | ||||
| Jones | Gold | Yes | 1 | ||||
| Clarke | Titanium | No | 2 | ||||
| Ranger | Platinum | No | 3 | ||||
| McKinley | Platinum | Yes | 3 | ||||
| Broadnax | Gold | No | 2 | ||||
| Burch | Titanium | Yes | 3 | ||||
| Totals | Ring Type | Cost | |||||
| Silver | $ 400.00 | ||||||
| Gold | $ 550.00 | ||||||
| Titanium | $ 700.00 | ||||||
| Platinum | $ 750.00 | ||||||
| Personalizing Surcharge | 5% | ||||||
| Interest Rate | 3% |
4 Replies
- 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%=VLOOKUP(B2,$G$10:$H$13,2,FALSE)*IF(D2="Yes",1.05,1)/(F2*12)Does this return your expected result?
