more than one condition for "if"

T

TrixieA

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
 
M

Mike H

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
 
Top