IF function Please HELP!!

[rawnaah]

How would one use IF function to determine the following please help...Thanks

SECONDARY TRANSPORT RATE:		251 TO 400 KM & >400 $	24 PER MT PER KM
SECONDARY TRANSPORT RATE:		101 TO 250 KM $		25 PER MT PER KM
SECONDARY TRANSPORT RATE:		31 TO 100 KM $		25 PER MT PER KM
SECONDARY TRANSPORT RATE:		11 TO 30 KM $		25 PER MT PER KM
SECONDARY TRANSPORT RATE:		<=10 $		600 PER MT

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[texasalynn]

Re: How would IF function be used here,Please HELP!

and you have the table setup like my example? the data sort by column B in the table?

 

[rawnaah]

Re: How would IF function be used here,Please HELP!

and you have the table setup like my example? the data sort by column B in the table?

Yeah tex,just like your example.

 

[texasalynn]

Re: How would IF function be used here,Please HELP!

ok so tried it and it works ok for me?

Excel 2010
	A	B	C	D
1	<=10 $	0	600 PER MT PER KM
2	11 TO 30 KM $	11	25 PER MT PER KM1
3	31 TO 100 KM $	31	25 PER MT PER KM2
4	101 TO 250 KM $	101	25 PER MT PER KM3
5	251 TO 400 KM & >400 $	251	24 PER MT PER KM
6
7
8	300	24 PER MT PER KM
9	254	24 PER MT PER KM
10	75	25 PER MT PER KM2
11	20	25 PER MT PER KM1
12	8	600 PER MT PER KM
Sheet1

Cell Formulas
Range	Formula
B8	=VLOOKUP(A8,$B$1:$C$5,2)
B9	=VLOOKUP(A9,$B$1:$C$5,2)
B10	=VLOOKUP(A10,$B$1:$C$5,2)
B11	=VLOOKUP(A11,$B$1:$C$5,2)
B12	=VLOOKUP(A12,$B$1:$C$5,2)

 

[rawnaah]

Re: How would IF function be used here,Please HELP!

ok so tried it and it works ok for me?

Excel 2010

	A	B	C	D
1	<=10 $	0	600 PER MT PER KM
2	11 TO 30 KM $	11	25 PER MT PER KM1
3	31 TO 100 KM $	31	25 PER MT PER KM2
4	101 TO 250 KM $	101	25 PER MT PER KM3
5	251 TO 400 KM & >400 $	251	24 PER MT PER KM
6
7
8	300	24 PER MT PER KM
9	254	24 PER MT PER KM
10	75	25 PER MT PER KM2
11	20	25 PER MT PER KM1
12	8	600 PER MT PER KM

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B8 =VLOOKUP(A8,$B$1:$C$5,2) B9 =VLOOKUP(A9,$B$1:$C$5,2) B10 =VLOOKUP(A10,$B$1:$C$5,2) B11 =VLOOKUP(A11,$B$1:$C$5,2) B12 =VLOOKUP(A12,$B$1:$C$5,2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thanks tex,i realized i was the one messing things up,it works perfectly.again thank you.