刀长显示问题

王每文 · 发表于 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

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

帐号		自动登录	找回密码
密码			立即注册

[求助] 刀长显示问题