请高手将 excel毫米英尺英寸的换算公式

2025-03-12 20:51:34
推荐回答(1个)
回答1:

‍=INT(CONVERT(A1,"cm","in")/12)&"英尺"&TEXT(ROUND(MOD(CONVERT(A1,"cm","in"),12),2),"# ???/???")&"英寸"
=INT(CONVERT(A1,"cm","in")/12)&"英尺"&TEXT(ROUND(MOD(CONVERT(A1,"cm","in"),12),2),"# ???/???")&"英寸"