If Statement for all row

[prakashjoshi87]

i have condition in one column and i want to use if statement for all row's which we have condition in column.

See here

Routing	ITEM 1
A	256,000
B	300,000
A	256000
B	300000

<colgroup><col width="102"><col width="64"></colgroup><tbody>
</tbody>

if routing =A then item 1 cost is 256000
if routing = B then item 1 cost is 300000
etc
now i want is condition for all row
Pls help

 

[Marcílio_Lobão]

prakashjoshi87, Good morning.

I'm not sure if I understood correctly your necessity.

Try to use:

	A	B
1	Routing	Item 1
2	a	=IF(A2="a",256000,IF(A2="b",300000,""))
3	b

<tbody>
</tbody>

Copy the formula of B2 down.

Is that what you're looking for?
I hope it helps.

 

[prakashjoshi87]

Thanks for Reply
But i want it on Vb code
see

ORDER QTY	PROCESS	Load for Process	Load for Process	Load for Process
45000	1+2+3	45000	45000	45000
50000	1+3	50000		50000
6000	1+2	6000	6000
65000	1+2+3	65000	65000	65000
70000	1+2	70000	70000

<tbody>
</tbody>

This is the sheet
in process column if i choose 1+2+3 then automatic load will show on process 1,process 2 and process
or if i choose 1+3 then load will show on process 1 and process 3

hope you understatnd

 

[proficient]

Go to link below, you will get want you want to...

http://www.mrexcel.com/forum/excel-questions/880872-need-help-if-statement.html