Hide #VALUE! - Is it possible?

[CasperA]

Is it possible in hide the display of the characters #VALUE! in those cells that do not yet display the result of a formula?

CA

 

[MARK858]

=IFERROR((A1),"")

or

=IFERROR(A1,"")

I don't see why you are putting the brackets around A1?

 

[CasperA]

or

I don't see why you are putting the brackets around A1?

Example:
In cell C10 I type the digit 1
In cell D10 I type the formula =Reconfig(C10) , which is a meaningless formula here
The result in D10 is the display of the characters #NAME?


If I follow the suggestion below:

=iferror(your formula,"")

and change the formula in D10 into:

=iferror(=Reconfig(C10),"")

An error message is displayed that Excel has a problem with this formula.

I do not understand, as I replaced the words your formula by what I think my formula was, namely =Reconfig(C10)

The error message appears whether I put brackets around C10 or not. What I am looking for is a way to avoid seeing #NAME? (or #VALUE!) in cases where a formula is not working because data is missing.

Thank you in advance for your clarification,

CasperA

 

[Michael M]

Is this a UDF

=Reconfig(C10)

Why don't you show use the real formula, rather than "meaningless"
You will always get a NAME error if the formula doesn't exist, as it can't be evaluated !!!

 

[gaz_chops]

Remove the 2nd = sign

=iferror(Reconfig(C10),"")

 

[CasperA]

Remove the 2nd = sign

=iferror(Reconfig(C10),"")

Thank you, gaz_chops, after the reply above from Michael M I realised I have been unclear with my question. The Reconfig formula is the following UDF and if I try to replace Reconfig(C10) by =iferror(Reconfig(C10),"" in D10 I still get an error message that Excel has problems with the formula. What I am basically looking for is a way to get rid of the display of #NAME? or #VALUE! in cases where a formula cannot return anything (except #NAME? or #VALUE!) because the cell that it is supposed to work on is empty instead of filled with the necessary data for calculation. Maybe it is not possible? I'd be happy if instead of #NAME? or #VALUE! nothing (visible) would be displayed. It's a cosmetic wish.

Regards,
CasperA

Function Reconfig(S As String)Dim V As Variant
V = Split(S, " ")
For i = 1 To UBound(V) + 1
Reconfig = Reconfig & i & "• " & V(i - 1) & " "
Next i
End Function

 

[CasperA]

-

 

[CasperA]

Is this a UDF

=Reconfig(C10)

Why don't you show use the real formula, rather than "meaningless"
You will always get a NAME error if the formula doesn't exist, as it can't be evaluated !!!

Thank you for your reply, Michael M,

I understand that my question was unclear. The Reconfig() is indeed a UDF. See above.


Regards,
CasperA

 

[MARK858]

Are you sure your Dim V as Variant isn't sat on the function line (like it is in the thread) rather than on the second line like it should be (as in the code below) as I get a 0 if C10 is empty?

Function Reconfig(S As String)
    Dim V As Variant, i As Variant
    V = Split(S, " ")
    For i = 1 To UBound(V) + 1
        Reconfig = Reconfig & i & "• " & V(i - 1) & " "
    Next i
End Function

 

[CasperA]

Are you sure your Dim V as Variant isn't sat on the function line (like it is in the thread) rather than on the second line like it should be (as in the code below) as I get a 0 if C10 is empty?

Function Reconfig(S As String)
    Dim V As Variant, i As Variant
    V = Split(S, " ")
    For i = 1 To UBound(V) + 1
        Reconfig = Reconfig & i & "• " & V(i - 1) & " "
    Next i
End Function

The UDF code is as you post it, sorry for the misrepresentation in the thread.

My general question is whether it is possible never to have the words #NAME? or #VALUE! displayed, regardless of whatever causes these characters to appear in a cell.

Regards,
CasperA

 

[MARK858]

Give me a real example of what is causing the error so I can test any answer I give you (you seem to have a strange aversion to actually asking a question with real/accurate information/examples).