Calculate amount of days paid in advance and apply percent discount

**djduality** · 07-13-2009, 02:42 AM

I have a table, as part of an assesment task i am doing, with dates, and a course fee.
Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount. I have tried several basica variations to the formula, and keep getting the same Err message.
Can someone please point me in the right direction to how i can calculate amount of days paid in advance and apply a % discount?

attached is the start of the assesment question.
Thanks in advance for anyone who is able to help me

You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid.
Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received:
• If students pay the course fee less than 7 days prior to the course commencing then they receive no discount.
• If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%.
• If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%.
• If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.

**oldchippy** · 07-13-2009, 02:45 AM

http://www.excelforum.com/forum-rule...rum-rules.html

Hi,

Welcome to the forum, please take a little time to read the forum rules then re-edit your title to your question

**djduality** · 07-13-2009, 11:45 PM

This is what i have so far. I thank anyone who is able to provide assistance

**windknife** · 07-13-2009, 11:55 PM

Try this
H2
=LOOKUP( G2/7,{0,1,2,3},{1,0.95,0.92,0.9})*F2

copied to H6

HTH,
windknife

**djduality** · 07-14-2009, 03:17 AM

thanks very much. Gladly appreciated. Thanks again for the quick replies and guidance

**deepest_blue** · 02-22-2010, 10:45 PM

ok so I know this is solved but, I am also doing the same course and was wondering in your excel doc where is your vlookup table? All the info you have there does not actually use the VLOOKUP function which is what this task is.
I personally am stuck on this also and my main issue is the VLOOKUP table setup. Any advice?

**oldchippy** · 02-23-2010, 04:41 AM

Hi,

A VLOOKUP wasn't used to solve this one in the end, look at djduality's attachment and the formula provided by windknife.

If that doesn't solve your problem, please post a new question in the appropiate forum - Thanks