pasquale.lanera

script with the IF statements

Discussion created by pasquale.lanera on Dec 19, 2012
Latest reply on Dec 20, 2012 by pasquale.lanera
Hello.
I am a researcher ISPRA (Institute of the Ministry of Environment has several hundred licenses for ArcGIS) and I need urgent help to create a procedure in VBA or Python.

The problem is as follows.
I have a shape file with the following numeric fields:
A = decimal number ranging from - 10 to + 10
B = decimal number ranging from - 10 to + 10
C = decimal number ranging from - 10 to + 10
D = average of A, B and C
Category = (initially all 0, and be filled with the result of the script).

I need a procedure based on the specific values ??????of the fields A, B, C and D for that record or object attribute to the Category field value.

The conditions for the same record or object are as follows:

- If both values ??????of A, B and C are <0 then assign at the Category field the value 1.
- In case at least one of the values ??????of A, B and C is> 0 and the value of D is <0, then it will assign at the Category field the value 2.
- If both the value of D is> 0, then it will assign at the Category field the value 1.

How I could implement this procedure? With a script in VBA or Python?

In this regard, the script should be written in the Field Calculator of the field "Category" ?

I tried to write the following script in Field Calculator but it get error:

if! M_IND! <0 and! PAH_IND! <0 and! HOC_IND! <0:
return 1
elif! M_IND! <0 or! PAH_IND! <0 or! HOC_IND! <0:
return 2
else:
return 3

Give me a hand?

Thank you and Merry Christmas.

Outcomes