=IF(COUNT(FIND(IF(B301=0," ",IF(OR(B301={10,20,30,40}),"零",IF(OR(B301={1,11,21,31,41}),"一",IF(OR(B301={2,12,22,32,42}),"二",IF(OR(B301={3,13,23,33,43}),"三",IF(OR(B301={4,14,24,34,44}),"四",IF(OR(B301={5,15,25,35,45}),"五",IF(OR(B301={6,16,26,36,46}),"六",IF(OR(B301={7,17,27,37,47}),"七",IF(OR(B301={8,18,28,38,48}),"八","九")))))))))),IF(C301=0," ",IF(OR(C301={10,20,30,40}),"零",IF(OR(C301={1,11,21,31,41}),"一",IF(OR(C301={2,12,22,32,42}),"二",IF(OR(C301={3,13,23,33,43}),"三",IF(OR(C301={4,14,24,34,44}),"四",IF(OR(C301={5,15,25,35,45}),"五",IF(OR(C301={6,16,26,36,46}),"六",IF(OR(C301={7,17,27,37,47}),"七",IF(OR(C301={8,18,28,38,48}),"八","九")))))))))))),"⊿"," ")
超过7层不能用,怎么办?
不想用加&的方法。
gfuyyu.rar
(1.81 KB, 下载次数: 28)
[ 本帖最后由 小沙拉paris 于 2009-5-10 17:07 编辑 ] |