Decimal Places
 

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.

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.

Decimal Places
 

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)




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.

--

Dave Peterson

Decimal Places
 

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

Decimal Places
 

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

Thank you

"David Biddulph" wrote:

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