Date Formula Query

[Brentwood]

Hi,

Struggling to get my head around how to create this formula.

I need a formula that will only apply a 10% discount if the item was purchased before a specific date.

Any ideas?

Thanks,

 

[jtakw]

Hi,

Something like this will get you started:

Book1
	A	B	C	D
1	Discount Expiration Date	Purchase Date	Purchase Price	Final Price
2	3/20/2018	3/21/2018	100	100
3		3/19/2018	150	135
Sheet1

Cell Formulas
Range	Formula
D2	=IF(B2<=A$2,C2*0.9,C2)

D2 formula copied down.

 

[jtakw]

Got your PM Brentwood, it's best if you can post your question and sample here.

But it's prohibited to help you Take or Past a Test, so you'll probably not receive any response.

 

[Brentwood]

Hey Jtakw,

Wasn't looking for someone to take the test, just some advice/tips on which formulas you would recommend me to use.

Thanks

 

[jtakw]

If you post Specific questions, sample data, and what you've done or come up with, then I'm sure I or someone will point you in the right direction.

 

[Brentwood]

Hi,

At the moment i have an IF formula which if true, uses a VLOOKUP.

Based on the result of this formula - i need to apply another IF statement for the discount rate, which is only applicable if within dates provided.

To make it easier i have attached the spreadsheet to one drive. Any help on nested IF statements would be great!

https://drive.google.com/file/d/1a25XRhFuMPFtyyhei_d9s2CkB96PL3Vu/view?usp=sharing

Thanks,