[newbie] formatting

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I'm trying to display a blank space (or nothing) when there is no difference
between two cells, as in:

=IF(C6-C15=0,"",C6-C15)

However, when the answer is 0 (i.e. logical test is true), I am getting:

0.00 under the number format
1.89... under the General Format

Any idea what format filter to apply?
 
Jon: Your answer may not be exactly 0. Your number may be small like
0.0000001 but general formating is only showing 2 decimal places.
 
That's it thanks :)

I updated my formula as follows:

=IF(ROUND(C6-C10,2)=0,"",C6-C10)

Btw, changed a bit the row contents, as you may note the change from C15 to
C10.
 
Back
Top