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

[TABLE="width: 166"]
<colgroup><col width="102"><col width="64"></colgroup><tbody>[TR]
[TD="class: et2, width: 102, align: center"]Routing[/TD]
[TD="class: et3, width: 64, align: center"]ITEM 1[/TD]
[/TR]
[TR]
[TD="class: et4, width: 102"]A[/TD]
[TD="class: et5, width: 64, align: center"]256,000[/TD]
[/TR]
[TR]
[TD="class: et4, width: 102"]B[/TD]
[TD="class: et5, width: 64, align: center"]300,000[/TD]
[/TR]
[TR]
[TD="class: et4, width: 102"]A[/TD]
[TD="class: et5, width: 64, align: center"]256000[/TD]
[/TR]
[TR]
[TD="class: et4, width: 102"]B[/TD]
[TD="class: et5, width: 64, align: center"]300000[/TD]
[/TR]
</tbody>[/TABLE]

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:

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Routing[/TD]
[TD="align: center"]Item 1[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]a[/TD]
[TD]=IF(A2="a",256000,IF(A2="b",300000,""))[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]b[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 454"]
<tbody>[TR]
[TD="class: et2, width: 101"]ORDER QTY[/TD]
[TD="class: et2, width: 80"]PROCESS[/TD]
[TD="class: et2, width: 129"]Load for Process[/TD]
[TD="class: et2, width: 72"]Load for Process[/TD]
[TD="class: et2, width: 72"]Load for Process[/TD]
[/TR]
[TR]
[TD="class: et2, width: 101"]45000[/TD]
[TD="class: et2, width: 80"]1+2+3[/TD]
[TD="class: et2, width: 129"]45000[/TD]
[TD="class: et2, width: 72"]45000[/TD]
[TD="class: et2, width: 72"]45000[/TD]
[/TR]
[TR]
[TD="class: et2, width: 101"]50000[/TD]
[TD="class: et2, width: 80"]1+3[/TD]
[TD="class: et2, width: 129"]50000[/TD]
[TD="class: et2, width: 72"][/TD]
[TD="class: et2, width: 72"]50000[/TD]
[/TR]
[TR]
[TD="class: et2, width: 101"]6000[/TD]
[TD="class: et2, width: 80"]1+2[/TD]
[TD="class: et2, width: 129"]6000[/TD]
[TD="class: et2, width: 72"]6000[/TD]
[TD="class: et2, width: 72"][/TD]
[/TR]
[TR]
[TD="class: et2, width: 101"]65000[/TD]
[TD="class: et2, width: 80"]1+2+3[/TD]
[TD="class: et2, width: 129"]65000[/TD]
[TD="class: et2, width: 72"]65000[/TD]
[TD="class: et2, width: 72"]65000[/TD]
[/TR]
[TR]
[TD="class: et2, width: 101"]70000[/TD]
[TD="class: et2, width: 80"]1+2[/TD]
[TD="class: et2, width: 129"]70000[/TD]
[TD="class: et2, width: 72"]70000[/TD]
[TD="class: et2, width: 72"][/TD]
[/TR]
</tbody>[/TABLE]

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