not calculating with certain figures

[Guest]

I have a SUM calculation at the end of a string of numbers. It won't
calculate correctly at times if I put in a figure in certain cells over a
certain amount. For example: In cell B35 I can put 84.79 and in B42 7.19
for a SUM of 91.98, but I can't put in 84.98 and 7.00 for the same SUM. I
get a FALSE message in the next column over (by the way, I have an IF-THEN
statement at the end of my columns that transfers the final calculation to
the adjacent column).

 

[David Biddulph]

I have a SUM calculation at the end of a string of numbers. It won't
calculate correctly at times if I put in a figure in certain cells over a
certain amount. For example: In cell B35 I can put 84.79 and in B42 7.19
for a SUM of 91.98, but I can't put in 84.98 and 7.00 for the same SUM. I
get a FALSE message in the next column over (by the way, I have an IF-THEN
statement at the end of my columns that transfers the final calculation to
the adjacent column).

Sorry, my crystal ball is clouded again. I can't read your formula from
here, so I can't tell you why it's behaving that way.

If you want an answer, tell us the formula that you think is misbehaving,
and tell us what's in each of the cells that feed into that formula.