How to how #n/a as an empty cell in an excel table (not chart)

[Jane_at_Stamma]

Hi - I'm trying to create a list in excel - from various sources - and where it comes up as #N/A or 0 I'd like just a blank.  How do I do this?

[#2]

you can use IFERROR or IFNA functions to make #NA results blank.

For zero values you can use IF function.

so it will be like this.

IFERROR( IF (your formula = 0 ; ""; your formula) ; "")

I

[#3]

Thank you. The current contents has for example, "=VLOOKUP(F2,FinalWorkshops,4)" ; how do I wrap that? Initial attempts failing.

[#4]

@Jane_at_Stamma 

Like

=IFNA( VLOOKUP( F2, FinalWorkshops, 4), "" )

[#5]

sorry, total novice here, so I typed in this
=IFERROR( IF (VLOOKUP(G7,FinalWorkshops,4)=0 ""; VLOOKUP(G7,FinalWorkshops,4) ; "")
which didn't work

[#6 · Accepted solution]

@Jane_at_Stamma 

You shall use or comma or semicolon as delimiter, depends on you regional settings, Mix doesn't work. If comma, it could be like

=IFERROR(
  IF( VLOOKUP( G7, FinalWorkshops, 4) = 0,
        "",
       VLOOKUP(G7,FinalWorkshops,4) ),
 "")

If you open attached file and check G16 it'll be the formula in your locale.

[#7]

Oh, thank you so much!!! That worked.

[#8]

Because your list separator is not ";". Your list seperator is ","

You can see it in your vlookup formula.

[#9]

@Jane_at_Stamma , you are welcome