Decimal Places

[Guest]

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.

 

[Guest]

try
=if(abs(c43-z42)>0.01,c43-Z42,"")

 

[Dave Peterson]

maybe...
=if(abs(C43=Z42)<.01,"",C43-Z42)

You may want to add round to the else portion, too:
=if(abs(C43=Z42)<.01,"",round(C43-Z42,2))

(or not)

 

[David Biddulph]

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

 

[Guest]

Thanks for all the responses. David's suggestion works best.

Thank you