Forum Discussion

Jane_at_Stamma's avatar
Jane_at_Stamma
Copper Contributor
Jul 03, 2022
Solved

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?

excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 03, 2022

    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.

  • Sekoleyte's avatar
    Sekoleyte
    Iron Contributor
    Jul 03, 2022
    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
    • Jane_at_Stamma's avatar
      Jane_at_Stamma
      Copper Contributor
      Jul 03, 2022
      Thank you. The current contents has for example, "=VLOOKUP(F2,FinalWorkshops,4)" ; how do I wrap that? Initial attempts failing.

Resources