\"ONLY NEED HELP WITH QUESTIONS #7 AND #10,,, STEP BY STEP, NOT JUST THE ANSWER

Question

"ONLY NEED HELP WITH QUESTIONS #7 AND #10,,, STEP BY STEP, NOT JUST THE ANSWER PLEASE" CORRECT!

nsert 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 8 Copy the formula from cell E5 to the range E6:E11. Apply Accounting number format to the range E5:E11 10 Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references

Explanation / Answer

#7) =IF(D5="Yes",C5+(C5*B21),C5)

Here in D5,under personalised section, we are checking if the attraibuted is Personalised( Yes or No). If the condition is true then we take the base price, i.e. C5 and add the surcharge from Cell B21. IF the condition is anything else other than Yes then we will get the output as only C5.

#10)=SUMIFS($E$5:$E$7,A5:A7,A5,$F$5:$F$7,F5)

So here is the problem, no month specified, so I will assume the following things:
If I have to find out the monthly payment for Dodson, I will search for Dodson in the name,use Total for Summation and see if the Years value is repeated.

I am using Sumifs( Range Criteria, Range...)

First range criteria is E5 to E7 which will check if the name is repeated or not, this range will be amtched with the first cell value i.e.E5. Second range criteria will be F5 to F7 which will check for Years and will see if the same Years value is repeated or not.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.