Numerical Logic colliding with Text

Sorry if this is answered elsewhere, my rule of thumb is if it doesn't show up in 30 minutes of searching online I've satisfied my karmic duty before posting =).

I have a monster of a sheet going and am working for research purposes. I dislike the interface of SPSS so I use excel to boil down my variables to a smaller state, to which it then goes back to SPSS for the hardcore analysis.

Unfortunately, this study has values of "N/A", "Missing", and "." (not entered), so it makes it a bit tricky for me.

Say I want to check 10 different scales to see if any are true:
=IF(OR(FJ6>=1,ZD6>=1,....etc),"Yes","No"))

Problem is the blasted program is reading ".", "Missing", and "N/A" as greater than one!!!!! I've found a way around by making monster formulas that first check that the field is not equal to those three text values, but there must be a faster way!

To see what I mean, put a period in one cell (like A1) and write =IF(A1>=1,"Yes","No") and you'll see it returns a Yes.

Do any of you know a function structure for number checking that does NOT include text? Does it have to do with cell formatting?