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...