=IF(LEN(TEXT(E10*F10*100,"###0"))<COLUMN(P:P)-COLUMN(),"",MId(TEXT(E10*F10*100,"###0"),LEN(TEXT(E10*F10*100,"###0"))-9+COLUMN(A:A),1))
烦劳能者详细解答
先谢过
加 介绍些学习网站最好
=IF(LEN(TEXT(E10*F10*100,"###0"))<COLUMN(P:P)-COLUMN(),"",MId(TEXT(E10*F10*100,"###0"),LEN(TEXT(E10*F10*100,"###0"))-9+COLUMN(A:A),1))
烦劳能者详细解答
先谢过
加 介绍些学习网站最好
楼主,学习EXCEL表格,请到 http://club.excelhome.net/index.php
我在这里学习了很多EXCEL表格知识