Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than one condition for "if"
Can anyone see where I am going wrong? It picks up the first 2 conditions,
but then doesn't get the last 3. I need 1-99 = p5*1.00 100-149, p5*2.50 150-249, p5*2.75 250-300,p5*3 301+, p5*3.25 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than one condition for "if"
Hi,
You don't provide too much information so here's a guess. Create a table somewhere that looks like this 1 1.00 100 2.50 150 2.75 250 3.00 301 3.25 In this example it's in A1 to B5 try this formula =P5*VLOOKUP(P5,A1:B5,2,TRUE) Note that column A of the table must be sorted as in the example. Mike "TrixieA" wrote: Can anyone see where I am going wrong? It picks up the first 2 conditions, but then doesn't get the last 3. I need 1-99 = p5*1.00 100-149, p5*2.50 150-249, p5*2.75 250-300,p5*3 301+, p5*3.25 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than one condition for "if"
I used the Vlookup, it did work. Thank you
Trixie. "Mike H" wrote: Hi, You don't provide too much information so here's a guess. Create a table somewhere that looks like this 1 1.00 100 2.50 150 2.75 250 3.00 301 3.25 In this example it's in A1 to B5 try this formula =P5*VLOOKUP(P5,A1:B5,2,TRUE) Note that column A of the table must be sorted as in the example. Mike "TrixieA" wrote: Can anyone see where I am going wrong? It picks up the first 2 conditions, but then doesn't get the last 3. I need 1-99 = p5*1.00 100-149, p5*2.50 150-249, p5*2.75 250-300,p5*3 301+, p5*3.25 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"countif" and "and" condition | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
In excel counting cells in a range which meet condition "Xand<X" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |