Iserror, 0

[kkondrat1]

=IF((OR(ISERROR(W13-F13),0)),"",W13-F13)

The above is the formula I am using (not working)

If w13-F13 returns an error I want "" to appear in the cell.

OR if the value is returned as 0

I want "" to return in the cell

 

[Frank Kabel]

Hi
try:
=IF(ISERROR(W13-F13),"",IF(W13-F13=0,"",W13-F13))

Question remains why W13-F13 could return an error. What
values do you have in these cells?

 

[Jack Schitt]

=IF(ISERROR(W13-F13),"",IF(W13-F13=0,"",W13-F13))

I think you have to nest the IF statements, because if any of the elements
within OR() returns an error then the expression as a whole will return an
error.

 

[Alex Delamain]

I have tried it with #N/A, #REF!, #DIV/0! in both F13 and W13 and i
returns "" as expected. It also returns the required result i
F13-W13=0.

I'm afraid it works perfectly for me