Hello,

I am trying to create a field that completes a simple IF function. Here is the formula currently: IF(Field1 ≥ "1320"; "Y"; "N").

The field does correctly identify all records that are greater than or equal to 1320, but for some reason, the field is marking "Y" for some, but not all records, that have values less than 1320. Field1 is an indexed number field.

Does anyone know what could possibly be causing this problem? Did I miss a step somewhere?

I would appreciate any help/suggestions!

To explain further on why the above changes are needed, think of how text gets sorted into alphabetical order. The rules for how you do that differ from a set of numbers assorted into ascending order.

If you compare text values, the following is a true statement.

"2" > "1000"

for the same reason that "big" will come after "Abracadabra" in an alphabetized list.