Forum Discussion

Barry2021's avatar
Barry2021
Copper Contributor
Dec 04, 2022
Solved

Get rid of #FIELD! in a stock data table

For example: Looking up the PE of a stock/ETF - ETF's do not have a PE and consequently show up as "#FIELD!" . This happens on several items and I would like to leave the cells with "#FIELD!" blank -...
excel
  • Barry2021's avatar
    Barry2021
    Copper Contributor
    Dec 04, 2022

    Detlef_Lewin 

     

    Thanks Detlef - I did not see the answer to my question in this link

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Dec 04, 2022

      Barry2021 

      Try IFERROR().

       

      • Barry2021's avatar
        Barry2021
        Copper Contributor
        Dec 30, 2022
        =IFERROR([@[MS Call]].[P/E],"") - works
        -- thanks

Resources