Forum Discussion
Jane_at_Stamma
Jul 03, 2022Copper Contributor
How to how #n/a as an empty cell in an excel table (not chart)
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?
- Jul 03, 2022
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.
Sekoleyte
Jul 03, 2022Iron Contributor
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
For zero values you can use IF function.
so it will be like this.
IFERROR( IF (your formula = 0 ; ""; your formula) ; "")
I
- Jane_at_StammaJul 03, 2022Copper ContributorThank you. The current contents has for example, "=VLOOKUP(F2,FinalWorkshops,4)" ; how do I wrap that? Initial attempts failing.
- SergeiBaklanJul 03, 2022Diamond Contributor
- Jane_at_StammaJul 03, 2022Copper Contributorsorry, total novice here, so I typed in this
=IFERROR( IF (VLOOKUP(G7,FinalWorkshops,4)=0 ""; VLOOKUP(G7,FinalWorkshops,4) ; "")
which didn't work