+ -
当前位置:首页 → 问答吧 → 求高手帮忙,if then else语句

求高手帮忙,if then else语句

时间:2011-08-29

来源:互联网

问题点:当spdData.CellText(ecCustomerOption, Row)为JP或者FO或者TO
并且spdData.CellText(ecOption, Row)为BF1或者BF8或者BF9或者BFB
那么spdData.CellText(ecCheck1, Row)显示NG,否则OK
我写的代码如下:
  If (spdData.CellText(ecCustomerOption, Row) = "JP" Or spdData.CellText(ecCustomerOption, Row) = "F0" Or spdData.CellText(ecCustomerOption, Row) = "T0") And spdData.CellText(ecOption, Row) = "BF1" Or spdData.CellText(ecOption, Row) = "BF8" Or spdData.CellText(ecOption, Row) = "BF9" Or spdData.CellText(ecOption, Row) = "BFB" Then

  spdData.CellText(ecCheck1, Row) = "NG"
  Else: spdData.CellText(ecCheck1, Row) = "OK"

  End If
但测试显示,如果(spdData.CellText(ecCustomerOption, Row)=“LN” 并且spdData.CellText(ecOption, Row) = "BF9"的话,spdData.CellText(ecCheck1, Row)也显示NG
请高手指出问题点,多谢!

作者: rachelchen888   发布时间: 2011-08-29

我自己已经找到问题点了,O(∩_∩)O哈哈哈~

作者: rachelchen888   发布时间: 2011-08-29

热门下载

更多