å设Aååå
¥äºEXCELçµåè¡¨æ ¼è®¤å¯çæ¥ææ°æ®ï¼åB1åå
æ ¼åå
¥å
¬å¼
=IF(A1="","","第"&IF(OR(--TEXT(A1,"m")={1,2,3}),"第ä¸å£åº¦"ï¼IF(OR(--TEXT(A1,"m")={4,5,6}),"第äºå£åº¦"ï¼IF(OR(--TEXT(A1,"m")={7,8,9}),"ä¸"ï¼"å")))&"å£åº¦"ï¼"")
ä¸æå¡«å
å
¬å¼
追çå设Aååå
¥äºEXCELçµåè¡¨æ ¼è®¤å¯çæ¥ææ°æ®ï¼åB1åå
æ ¼åå
¥å
¬å¼
=IF(A1="","","第"&IF(OR(--TEXT(A1,"m")={1,2,3}),"ä¸"ï¼IF(OR(--TEXT(A1,"m")={4,5,6}),"äº"ï¼IF(OR(--TEXT(A1,"m")={7,8,9}),"ä¸"ï¼"å")))&"å£åº¦"ï¼"")
ä¸æå¡«å
å
¬å¼