To keep cell blank instead of #VALUE! when apply formula

[Kenor]

Hi All,

How to keel cell blank instead of #VALUE! ?
I just want to use simple formula I10-L10.
I try to use this formula >> '=IF((ISERROR(formula)),"",(formula))
Yes, the cell with #VALUE before become blank, but some cells that should have value (e.g. 500 - 0 = 500) also become blank.

Someone can help me?

 

[Logit]

Thanks for the input. I'm having a very bad day here. My brain simply is not functioning.

 

[Kenor]

=IFERROR("",I16-L16)

yes ..still same..#VALUE! still come out

 

[Peter_SSs]

In you first examples all rows had a number in column I but now it appears some of them do not. Try this instead of what I suggested before.

=IF(COUNT(I16,L16),N(I16)-N(L16),"")

 

[Kenor]

In you first examples all rows had a number in column I but now it appears some of them do not. Try this instead of what I suggested before.

=IF(COUNT(I16,L16),N(I16)-N(L16),"")

Yes...finally..thanks a lot for both of you

 

[Peter_SSs]

You're welcome.

BTW, if you had posted your sample with XL2BB as suggested instead of a picture you would have had your answer about 24 hours earlier.