did not work not sure if I put it in right...can you please show me exactly
what it should say?
should it be...
=if(c5="E",+IF(G15="","",G15*VLOOKUP(G15,{0,0.25;1 00,0.2;999,0.15},2)),g5*.2)
or...
=if(c5="E",(G15="","",G15*VLOOKUP(G15,{0,0.25;100, 0.2;999,0.15},2)),g5*.2)
or what?
"Don Guillett" wrote:

try
=if(c5="E", yourformula,g5*.2)

--
Don Guillett
SalesAid Software

"formula using percentage question"
oft.com wrote in message
...
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