(Answered) Inland Jewelers Date 1/11/2017 Name Dodson Jones Clarke Ranger McKinley Broadnax Burch Totals Ring Type Silver Gold Titanium Platinum Ring Type...

Inland Jewelers Date 1/11/2017 Name Dodson Jones Clarke Ranger McKinley Broadnax Burch Totals Ring Type Silver Gold Titanium Platinum Ring Type...

Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references.   whats the function? in excelDate

 

1/11/2017

 

Name

 

Ring Type

 

Cost

 

Personalized

 

Total

 

Years

 

Monthly

 

Payment

 

Dodson

 

Silver

 

400.00

 

$

 

Yes

 

420.00

 

$

 

1

 

$35.57

 

Jones

 

Gold

 

550.00

 

$

 

Yes

 

577.50

 

$

 

1

 

48.91

 

$

 

Clarke

 

Titanium

 

700.00

 

$

 

No

 

700.00

 

$

 

2

 

30.09

 

$

 

Ranger

 

Platinum

 

750.00

 

$

 

No

 

750.00

 

$

 

3

 

21.81

 

$

 

McKinley

 

Platinum

 

750.00

 

$

 

Yes

 

787.50

 

$

 

3

 

22.90

 

$

 

Broadnax

 

Gold

 

550.00

 

$

 

No

 

550.00

 

$

 

2

 

23.64

 

$

 

Burch

 

Titanium

 

700.00

 

$

 

Yes

 

735.00

 

$

 

3

 

21.37

 

$

 

Totals

 

4,400.00

 

$

 

4,520.00

 

$

 

204.30

 

$

 

Ring Type

 

Cost

 

Silver

 

400.00

 

$

 

Gold

 

550.00

 

$

 

Titanium

 

700.00

 

$

 

Platinum

 

750.00

 

$

 

Personalizing

 

Surcharge

 

5%

 

Interest Rate

 

3%

 

Inland Jewelers

 

Student Name

 

ClassRing

 

_Student_exploring_e02_grader_h1.xlsx

 

---

Solution details:

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 02, 2020

EXPERT

Tutor

ANSWER RATING

YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.