AnsweredAssumed Answered

Why is an IF Function (greater than equal to) returning incorrect results?

Question asked by megan1713 on Apr 18, 2018
Latest reply on Apr 18, 2018 by megan1713


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!

Outcomes