this is what I currently have in H5:
=+IF(G5="","",G5*VLOOKUP(G5,{0,0.25;100,0.2;999,0. 15},2))
which means if the price is in a certain range then it will be multiplied by
a certain percentage....
is it possible to add a condition that IF C5=E then use the above formula,
but if C5=S use 20% of G5