View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hawk hawk is offline
external usenet poster
 
Posts: 8
Default not calculating with certain figures

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).