<p align="left">SUM(--($A$15:$A15<>$A$14:$A14)) 执行不了</p><p align="left">提示:</p><table cellspacing="0" cellpadding="0" width="122" border="0" style="WIDTH: 92pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="122" style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 3904;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="122" height="19" xerr="#VALUE!" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 92pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">#VALUE!</font></td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="122" border="0" style="WIDTH: 92pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="122" style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 3904;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="122" height="19" xerr="#VALUE!" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 92pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><pre></pre><pre>如果使用f9键,将公式转换为结果显示并应用的话,就可以得到想要的结果。</pre><pre>求助高手这是怎么回事??????</pre><pre>谢谢!</pre></td></tr></tbody></table>
svh3mgFP.rar
(2.76 KB, 下载次数: 10)
<br/>
[此贴子已经被作者于2008-9-27 9:22:57编辑过] |