如上图所示显示比例。
实现公式:
=IFERROR(SUBSTITUTE(TEXT(A2/B2,"0/"&REPT("#",LOG10(B2)+1)),"/",":"),0)
本文链接:https://my.lmcjl.com/post/13883.html
展开阅读全文
如上图所示显示比例。
实现公式:
=IFERROR(SUBSTITUTE(TEXT(A2/B2,"0/"&REPT("#",LOG10(B2)+1)),"/",":"),0)
本文链接:https://my.lmcjl.com/post/13883.html
4 评论