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?

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

--
Gary''s Student - gsnu200845

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" wrote:

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?

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.

"joel" wrote:

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" wrote:

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?