Iserror, 0

K

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
 
F

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

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.
 
A

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
 
Top