Decimal Places
try
=if(abs(c43-z42)0.01,c43-Z42,"")
"JHL" wrote:
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.
|