Data format

[Guest]

I have a spreadsheet that I am pulling figures from several different
worksheets. They are all added/subtracted together. Then once I have my
figures pulled together I balance. However, when I subtract two figures
sometime the difference reads 0 sometimes it reads -. Normally this would
bother me, but I have a If statement which says, if this cell is <>0 then
"Balanced". So, what happens is when the - appears the spreadsheet says
balanced, when the 0 appears the cell does not say "Balanced". What would
make this happen?

 

[JE McGimpsey]

You're seeing small rounding errors give a non-zero result in your sum.
The values are small, though, so they'll display as zero.

You could wrap your sum (or individual calculations) with ROUND(), e.g.:

A11: =ROUND(SUM(A1:A10),2)

or you could change your IF statement to allow for small rounding
errors, e.g.:

=IF(ABS(A11)<0.001,"Balanced","Not Balanced")