# Step Formula Step 2

#### GoTen

##### New Member
A1=IF(OR(ISERROR(แผนผลิต!E380),(แผนผลิต!E380)="NoData"),0,(แผนผลิต!E380))
A2=IF(OR(ISERROR(แผนผลิต!E382),(แผนผลิต!E382)="NoData"),0,(แผนผลิต!E382))
A3=IF(OR(ISERROR(แผนผลิต!E384),(แผนผลิต!E384)="NoData"),0,(แผนผลิต!E384))

ทำให้สูตรเวลาลากมาแล้วกระโดด แบบนี้อย่างไรบ้างครับ Thank You very much

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### GoTen

##### New Member
i Want Copy A1 to A100 Formula Goto Step 2 .Form Subject

#### snasui

##### Board Regular
A1=IF(OR(ISERROR(แผนผลิต!E380),(แผนผลิต!E380)="NoData"),0,(แผนผลิต!E380))
A2=IF(OR(ISERROR(แผนผลิต!E382),(แผนผลิต!E382)="NoData"),0,(แผนผลิต!E382))
A3=IF(OR(ISERROR(แผนผลิต!E384),(แผนผลิต!E384)="NoData"),0,(แผนผลิต!E384))

ทำให้สูตรเวลาลากมาแล้วกระโดด แบบนี้อย่างไรบ้างครับ Thank You very much

If the results that you want are number. Try this,

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,INDEX(แผนผลิต!\$E\$380:\$E\$400,2*(ROWS(แผนผลิต!\$E\$380:E380)-1)+1)))

If number or text,

=IF(ISERROR(INDEX(แผนผลิต!\$E\$380:\$E\$400,2*(ROWS(แผนผลิต!\$E\$380:E380)-1)+1)),0,IF(INDEX(แผนผลิต!\$E\$380:\$E\$400,2*(ROWS(แผนผลิต!\$E\$380:E380)-1)+1)="NoData",0,INDEX(แผนผลิต!\$E\$380:\$E\$400,2*(ROWS(แผนผลิต!\$E\$380:E380)-1)+1)))

----
snasui
(คนควน)

Replies
5
Views
242
Replies
3
Views
79
Replies
0
Views
62
Replies
3
Views
214
Replies
3
Views
169

1,190,810
Messages
5,983,044
Members
439,816
Latest member
aggelos

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back