You want to enter a formula to calculate the total registration paid based on th

Question

You want to enter a formula to calculate the total registration paid based on the data in the Registration Fee/Discount Area. All Players pay the seasonal fee $75. Anyone who registers at least 4 week early before the season starts received a $5 discount. Because the formula results are based on the registration date, you need touse an IF functions in cell E34 to determine whether the players will received the $5 discount. Build the IF function using defined names.

Hint; Logical test should read Early_Registration="Yes"

Value if ture: anser should be defined name

Value if faulse: 0

In cell E36 enter a formula based on defined names to calculate the registraion total, which is $70.

Registration Data Plaver Measurements Age Shirt Sock 12/1/2016 3 Registration Date 4 Plaver Name 5 Age Group 6 Shirt Size 7 Sock Size 8 Early Registration Yes 9 Parent 10 Address 11 City State Zip Medford, OR 97504 12 Telephone 13 Grol U4 U5 U6 U7 U8 U9 U10 Size Size XSH SH Sand U5 SM SH XSM SM James Smith 123 Main Street 541-555-1111 Registration Fee/Discount Season Fee 75 Discount Amount 15 16 17

Explanation / Answer

There are few assumptions first-
1. I am assuming you are calculating difference between today and registraion date (if not, change today function to a particular date)
2. I am assuming registratoin date is given in 'Sheet1' at B3.
3. Taking 4*7= 28 days for calculating discounted price or not

Now Define three name rangesas given below-

registration_date =Sheet1!$B$3
early_registration = IF(DAYS(TODAY(),registration_date)>28,"Yes",0)
discount = IF(early_registration="Yes",5,0)

Put following formulaes in cells
in E34: =discount
in E36: =IF(discount=5,70,75)

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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