王每文 发表于 2015-6-29 17:32:20

刀长显示问题

刀长显示问题
当Sheet2!I8="NO HOLDER"显示为IF(Setup!C8<>"",Setup!D8,Setup!Y8-Sheet2!N8+2)其他情况下显示IF(Sheet2!V8="","",Sheet2!V8)
求这样效果的可用代码一份
=IF(Sheet2!I8="NO HOLDER","Setup!C8<>"",Setup!D8,Setup!Y8-Sheet2!N8+2",IF(Sheet2!V8="","",Sheet2!V8))
=IF(Sheet2!I8="NO HOLDER","IF(Setup!C8<>"",Setup!D8,Setup!Y8-Sheet2!N8+2)",IF(Sheet2!V8="","",Sheet2!V8))

这两个自己想出来的可都失败了！

流浪的欢欢 发表于 2015-6-29 23:10:09

能看懂的就是刀长增量2

15361733104 发表于 2015-6-30 00:21:42

完全看不懂咧 加油:)

zyz 发表于 2015-6-30 09:00:06

看不懂:):):):):):)

页: [1]
查看完整版本: 刀长显示问题