Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ideas for simplifying cell formulas | Excel Discussion (Misc queries) | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |