求教大神！为何下面公式遇到0就无法显示大写零出来的?显示Value！谢谢

J6:=IF(IF(W6上百,百位,"")="","",CHOOSE(IF(IF(W6上百,百位,"")=0,10,IF(W6上百,百位,"")),"壹","贰","叁","肆","伍","陆","柒","捌","玖","零"))可以改写为：=IF(IF(W6不上百,百位,"",CHOOSE(IF(IF(W6上百,百位,"")=0,10,IF(W6上百,百位,"")),"壹","贰","叁","肆","伍","陆","柒","捌","玖","零"))=IF(IF(LEN(INT(W6))>=3,LEFT(RIGHT(INT(W6),3)),"")="","",CHOOSE(IF(IF(LEN(INT(W6))>=3,LEFT(RIGHT(INT(W6),3)),"")=0,10,IF(LEN(INT(W6))>=3,LEFT(RIGHT(INT(W6),3)),"")),"壹","贰","叁","肆","伍","陆","柒","捌","玖","零"))这是一个多么糟糕的公式？拖沓、累赘、晦涩后面的就不分析了。