two formulas in one cell
 

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

two formulas in one cell
 

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

two formulas in one cell
 

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

two formulas in one cell
 

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)
--
Don Guillett
SalesAid Software

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