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]

=IFERROR(formula,"",formula)

Or perhaps :

=IFERROR(A1,"",Formula)

A1 replace with specific cell

 

[Peter_SSs]

Can you post a small sample with XL2BB and include some rows that produce the error and some where you have the example like 500 - 0?

 

[Kenor]

=IFERROR(formula,"",formula)

Or perhaps :

=IFERROR(A1,"",Formula)

A1 replace with specific cell

I already try but seems like can't proceed

 

[RoryA]

IFERROR only takes two arguments:

=IFERROR(formula,"")

 

[Kenor]

Can you post a small sample with XL2BB and include some rows that produce the error and some where you have the example like 500 - 0?

Hi, Sorry I don't know how to use XL2BB, need to install first right?

Actually my problem as below;

I apply same formula for both picture, but when L16, L17, L18 have no value, O16 ~ O18 also become blank.

 

[Kenor]

IFERROR only takes two arguments:

=IFERROR(formula,"")

I try but also same.

 

[Peter_SSs]

need to install first right?

Yes, follow the XL2BB hyperlink in post #3 or my signature block below.

My guess is that column L contains a formula returning "" which is why I was asking for a sample with XL2BB as it would confirm one way or the other.
In any event, see if this works.

=I10-N(L10)

 

[Logit]

=IFERROR("",I16-L16)

 

[Peter_SSs]

=IFERROR("",I16-L16)

That will always return a null string and never return I16-L16.

BTW, rather than use the vba tag, the forum has a specific tag for formulas: