如题所述
建议ï¼è®¾ç½®ä¸ä¸ªåå
æ ¼ä¸ºå°åéé¢ãä¾å¦ç¨B7åå°åçæ»éé¢ï¼ç¨æ¥æ±æ»Cå°Låä¾çæ°åå计
ç¶åç¨å½æ°ï¼
=IF(B7<>0,NUMBERSTRING(B7,2)&"å ","")&IF(AND(E211=0,G211=0),"",IF(B7<>0,IF(E211<>0,NUMBERSTRING(E211,2)&"è§","é¶"),IF(E211<>0,NUMBERSTRING(E211,2)&"è§","")))&IF(G211<>0,NUMBERSTRING(G211,2)&"å",IF(AND(B7=0,E211=0),"","æ´"))
ç¶åç¨å½æ°ï¼
=IF(B7<>0,NUMBERSTRING(B7,2)&"å ","")&IF(AND(E211=0,G211=0),"",IF(B7<>0,IF(E211<>0,NUMBERSTRING(E211,2)&"è§","é¶"),IF(E211<>0,NUMBERSTRING(E211,2)&"è§","")))&IF(G211<>0,NUMBERSTRING(G211,2)&"å",IF(AND(B7=0,E211=0),"","æ´"))
温馨提示:答案为网友推荐,仅供参考