[求助] LEN函数，看帮助后，实践操作越来越不明白了

hyk86223

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 结果</p><p>LEN(11.1-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18</p><p>LEN(11.2-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17</p><p>LEN(11.3-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17</p><p>LEN(11.4-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3</p><p>LEN(11.5-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</p><p>LEN(11.6-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</p><p>LEN(11.7-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17</p><p>LEN(11.8-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17</p><p>LEN(11.9-11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</p><p>请问这个结果为什么不多等于3&nbsp; ？&nbsp;&nbsp;&nbsp;函数参数0.* 不多是3个字符个数？</p>

ayxlzz

是有点奇怪，等待高手解释

蝶·舞

存在浮点运算

勤快的猫

<p>[em06]</p><p>&nbsp;</p>[em06]

zhh823543

<p>浮点运算造成:</p><p><table border="0" cellspacing="0" cellpadding="0" width="324" style="WIDTH: 243pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="324" style="WIDTH: 243pt; mso-width-source: userset; mso-width-alt: 10368;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" width="324" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 243pt; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.1-11)=LEN(0.0999999999999996)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.2-11)=LEN(0.199999999999999)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.3-11)=LEN(0.300000000000001)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.4-11)=LEN(0.4)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.5-11)=LEN(0.5)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.6-11)=LEN(0.6)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.7-11)=LEN(0.699999999999999)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.8-11)=LEN(0.800000000000001)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font face="宋体">LEN(11.9-11)=LEN(0.9)</font></td></tr></tbody></table></p>