|
刀长显示问题
当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))
这两个自己想出来的可都失败了!
|
|