Hi,
I currently have a query about a formula that i have designed.
<d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
<d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
<d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
=IF(D18<D27,VLOOKUP(C18,B13:D15,2,FALSE),0)
I need to add a discount percentage, that is applied if the purchase is made before a specific date of to this formula.
Would any one know how to do this?
Link to spreadsheet
https://drive.google.com/file/d/1a25XRhFuMPFtyyhei_d9s2CkB96PL3Vu/view?usp=sharing
any help would be greatly appreciated.
Thanks,</d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
</d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
</d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
I currently have a query about a formula that i have designed.
<d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
<d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
<d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
=IF(D18<D27,VLOOKUP(C18,B13:D15,2,FALSE),0)
I need to add a discount percentage, that is applied if the purchase is made before a specific date of to this formula.
Would any one know how to do this?
Link to spreadsheet
https://drive.google.com/file/d/1a25XRhFuMPFtyyhei_d9s2CkB96PL3Vu/view?usp=sharing
any help would be greatly appreciated.
Thanks,</d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
</d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
</d$27,vlookup($c$18,$b$13:$d$15,2,false),0)
Last edited: