excel如何把前面三个单元格的数字转换成一个单元格中的分数

显示全部楼层 · 2011-11-21 10:38:06

可用此函数=TEXT(单元格,"# ?/??????")说明：括号里的问号：??????的数量越多，则计算得越精确你可设为1个，2个，3个。。。更多要想把分母统一为16，将公式改为：=TEXT(D1,"# ?/16")即可然后就是通过 &把几个单元格的内容链接起来合并题意可编辑以下函数：=TEXT(A1,"# ?/16")&" W X "&TEXT(B1,"# ?/16")&" L X "&TEXT(C1,"# ?/16")&"H"...

千问 · 2011-11-21 10:38:06

只能转换为文本后再操作分母为2：=TEXT($A$1,"# ??/2")分母为4：=TEXT($A$1,"# ??/4")分母为8：=TEXT($A$1,"# ??/8")分母为16：=TEXT($A$1,"# ??/16")分母为32：=TEXT($A$1,"# ??/32")........剩下的随你喜欢了...

千问 · 2011-11-21 10:38:06

D1输入=TEXT(A1,"# ?/?")&" W X "&TEXT(B1,"# ?/16")&" L X "&C1&"H"...

千问 · 2011-11-21 10:38:06

在D1输入：=IF(A1=INT(A1),A1,TEXT(A1,"# ?/16"))&" W X "&IF(B1=INT(B1),B1,TEXT(B1,"# ?/16"))&" L X "&IF(C1=INT(C1),C1,TEXT(C1,"# ?/16"))&"H"向下填充。...