two formulas in one cell

  • Thread starter formula using percentage question
  • Start date
F

formula using percentage question

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
 
F

formula using percentage question

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;100,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?
 
D

Don Guillett

Pretty self explanatory given your criteria here if your basic formula
works. TEST it first.
you
is it possible to add a condition that IF C5=E then use the above formula,
but if C5=S use 20% of G5
me
=if(c5="E", yourformula,g5*.2)

should be
IF(G15="","",G15*VLOOKUP(G15,{0,0.25;100,0.2;999,0.15},2)) Tested OK????
if(c5="E",IF(G15="","",G15*VLOOKUP(G15,{0,0.25;100,0.2;999,0.15},2)),g5*2)
 
Top