ITO - Formulas

Hamzalaalaoui

Hello,

I am trying to understand an abnormal behaviour in ITO formulas. My objective is to verify whether the building storey name corresponds to the correct elevation. For example, I am using the following formula:

IF(AND(C=“E-R+1b”; D=“220,050”); “OK”; “Non conforme”)

However, even when the first row is correct, the column still returns values where both conditions are not met.

Matti

For the numeric values I recommend compare value with tolerance
IF(ABS(target - actual) <= tolerance;“OK”;“NOT OK”)

Hamzalaalaoui

Thank you soo much for your reply, i have managed to find a solution similar to this where i creat a column that is equal to colum D to fix the unit of elevation and then in another column compare between the target number and actual.
Have a nice day