Forum Discussion

Excelo0's avatar
Excelo0
Copper Contributor
Sep 01, 2023
Solved

Urgent - How do I ignore "n.a." values in cells when building an IF+AND formula?

Hi,    I want my IF+AND formula to ignore cells with the value "n.a.". I have a big data set in Excel where some cells contain the value n.a. hardcoded. I want to ignore these n.a. values in my for...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Sep 01, 2023

    Excelo0 

     

    =IF(AND(A1:C1>=3, ISNUMBER(A1:C1)),"Pass","No Pass")

HansVogelaar's avatar
HansVogelaar
MVP
Sep 01, 2023

Excelo0 

 

=IF(AND(A1:C1>=3, ISNUMBER(A1:C1)),"Pass","No Pass")

  • Excelo0's avatar
    Excelo0
    Copper Contributor
    Sep 01, 2023
    Thank you, much appreciated. Golden star to you Sir! Please go into the weekend feeling like the hero you are!

Resources