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...