Sage 100

I have a client who just converted FrX reports over to Sage Intelligence. They have multiple tabs on their reports and use a macro to hide zero rows. The hide zero rows macro is working fine but one of the cells is not reading as 0 when it should be. We narrowed this down to a formula where the transactions behind the formula add up to 0 and when cell is formatted as number or currency, it shows zero. However when it is in general format it shows scientific notation (4.65661E-10) with a large value. The macro is reading this as not zero and so not hiding the row. Any ideas on why the formula is not reading the cell as zero? I have attached an example of it happening including the macro. Thanks for any help!

Could your macro look for absolute value < .01 instead of 0?

do something like =ROUND(D10,0.01) this will result in zero if it has that problem. if you want to force the weird number =(0.09+0.01-0.1) will do the trick. explanation of the problem http://www.excelforum.com/excel-general/396049-why-0-09-0-01-0-1-is-not-equal-to-0-09-0-01-0-1-a.html

I've handled this by using an absolute value formula in combination with an if/then statement, and keying on the result if it is less than 1: if(abs(A+B+C)<1,0,abs(A+B+C))

Thanks, these are great suggestions. I will try with the client and let you know how they worked.

Clarification of what I wrote earlier. Meant to say .01, not 1.

The ABS formula worked perfectly! Thank you all for the help!