Question
Inland Jewelers Date 2023-09-29 A B C D E F G Name Ring Type Cost Personalized Total Years Monthly Payment Dodson Silver $ 400.00 Yes
| Inland Jewelers | ||||||
| Date | 2023-09-29 | |||||
| A | B | C | D | E | F | G |
| 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% |
Insert an IF function in cell E5 to calculate the total due. If a student has chosen to personalize the ring, there is an additional charge of 5%, located in cell $B$21 that must be added to the cost of the ring; if not the student only pays the base price. Use appropriate relative and absolute cell references.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Quantitative Analysis For Management
Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Hale
14th Edition
0137943601, 9780137943609
