(0.00)

  • Thread starter Thread starter TH52
  • Start date Start date
T

TH52

I have a spreadsheet where I am trying to sum a column of 2 digit decimal
numbers. When it is summed, I get (0.00). Expanding out the decimals of the
sum field, I am finding numbers in the 10th digit to the right of the
decimal. This sum field is defines as only 2 digit decimal like the rest of
the numbers. Why would excel do this?
 
Hi,
that happens because you have formulas that came from calculations where you
have more than 2 decimals, let say one calculation is 0.0002 - 0.000000002
a work around is to add an if statement to the formula like

=IF(+F4-F5>0.001,"",F4-F5)

in that way will fill the cell with a blank

if this helps please click yes, thanks
 
Back
Top