[newbie] formatting

[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?

 

[Gary''s Student]

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

 

[joel]

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.

 

[Jon]

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.