two formulas in one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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)
 
Back
Top