Numerical Logic colliding with Text

[Feinam]

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?

[Feinam]

I'm temporarily working around the issue by making the argument impossible for text... =IF(A1*2>=1,"Yes","No"). When attempting to multiply "Missing" by 2, it returns a #VALUE! error.

Problem is, my solution is rather crude and will not work in other applications. Also, if I put constraints on the range like =IF(AND(A1>=1,A1<=100),"Yes","No") then text is not counted as a true value. That limits my ability as well.

Any way to do this simply?

[daddylonglegs]

You can check to see if the value is numeric, e.g.

=IF(AND(ISNUMBER(A1+0),A1>=1),"Yes","No")

[Feinam]

I owe you big time =), thank you.

I tested it and I'm assuming the + 0 is just an additional optional usage?

[daddylonglegs]

You may not need the +0.

I included it in case you might have numbers formatted as text, e.g. if you have "5" in A1 but it's text formatted then ISNUMBER(A1) will return FALSE but if you use ISNUMBER(A1+0) the +0 "coerces" text formatted numbers to numeric, so you'd get TRUE