=if(ABS(C43-Z42)<0.01,"",C43-Z42)
--
David Biddulph

"JHL" wrote in message
...
I have the following formula: =if(C43=Z42,"",(C43-Z42))
Sometimes the cell is blank, other times I have either -0.00 or 0.00 .
Further research shows I need to show 8 decimals places or more to get the
difference.

The cells C43 and Z42 are formulas, but I believe all calculations are
formatted for 2 decimal places.

How can I increase the formula result to just show differences of of .01
or
more?

Thanks.