Help with positive and or negative data put into a field
Hi,
Can someone please help me , I have 10 fields which are populated with measured data.
The data can be positive or negative, but not greater than -10 or +10
If the data being measured is put into any of the fields, is less than or = -10 / + 10 then I want to populate another field with "pass"
but if the data being put into any of the fields is greater than -10 /+10 then I want to populate the other field with "fail"
This is measured data,microns so can be positive or negative.
Many thanks
