I am using the formula below to say if a cell is 0 then the message is
Balanced.
This has always worked ok until now, but if the cell is 0.009999 for
example, it reads Unbalanced. As this is a sheet with Number formatted to 2
decimal places I still want it to read Balanced. I have tried formatting the
cell in many different ways, even moving the cell elsewhere on the sheet, but
unable to find the solution.
I have checked all cells in the calculation chain for errors in inputting
which is giving me the rogue total, but to no avail.
Does it need a better formula than the one I have to specifically bar
numbers after 0.00 so that the cell will read Balanced? Help much
appreciated. Thanks.


IF(F46=0,"< Balanced ","< Unbalanced ")