Thread: Decimal Places
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JHL JHL is offline
external usenet poster
 
Posts: 56
Default 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.