数字和+ 0 [英] Sum of numbers + 0

问题描述

我遇到一个小问题。我使用 SUM 函数来计算某些数字。如果在范围内加上零，则不显示零。我不知道为什么

A1

  = SUM（B1：R1）*  -  1 
  

C1到L1

  266864 -100000 -15136.15 -23688.82 -120870 -7169 -5550 1224 -0.03 4326 
  

A2

  = SUM（B2：R2）*  -  1 
  pre> 
 
 
 C2到M2 
  = SUM（C3：C3） = SUM（D3：D3）= SUM（E3：E3）= SUM（F3：F3）= SUM（G3：G3）= SUM（H3：H3）= SUM（I3：I3）= SUM（J3：J3）= SUM（K3：K3）= SUM（L3：L3）= SUM（M3：M3）
  
 A3 
  = SUM（B3：R3）*  -  1 
  
 C3到M3 
  266864 -100000 -15136.15 -23688.82 -120870  - 7169 -5550 1224 -0.03 4326 0 
  
 A1显示0，但A2和A3显示9.09E- 
解决方案
数字9.09E-13是另一种方式（科学符号）说0.000000000000909495，一个非常小的小数号。你所遇到的是一个  ROUND功能或类似的东西删除错误（如果你必须）。
 
 
 
参见更多信息，浮点运算可能会给Excel中的不准确结果。
 
I am having a problem with a small number. I am using SUM function to sum certain numbers. If I add a zero to the range, it is not displaying zero. I don't know why. 

A1 
=SUM(B1:R1)*-1
C1 to L1 
266864  -100000 -15136.15   -23688.82   -120870 -7169   -5550   1224    -0.03   4326
A2 
=SUM(B2:R2)*-1
C2 to M2 
=SUM(C3:C3) =SUM(D3:D3) =SUM(E3:E3) =SUM(F3:F3) =SUM(G3:G3) =SUM(H3:H3) =SUM(I3:I3) =SUM(J3:J3) =SUM(K3:K3) =SUM(L3:L3) =SUM(M3:M3)
A3
=SUM(B3:R3)*-1
C3 to M3 
266864  -100000 -15136.15   -23688.82   -120870 -7169   -5550   1224    -0.03   4326    0
A1 is displaying 0, but A2 and A3 displays 9.09E-13
解决方案
The number 9.09E-13 is another way (scientific notation) of saying 0.000000000000909495, a very small decimal number. What you are experiencing is a 15 digit precision floating point error.

    

Typically, you would use the ROUND function or something similar to remove the error (if you have to).

See Floating-point arithmetic may give inaccurate results in Excel for more information.

                        
这篇关于数字和+ 0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！