Calculate field using IF

1526
2
Jump to solution
07-12-2016 10:14 AM
Labels (1)
HectorBorro1
Occasional Contributor

Hello,

I have a list of polygons that have values from -140 to +1 where the negatives are outliers and should have value = 0

How can I calculate a value using IF statement? Having some trouble with Python as it is new for me...

In excel the formula would be: =if(A1<0,0,A1)

How can I achieve this in ArcGIS pro v 1.2?

0 Kudos
1 Solution

Accepted Solutions
JayantaPoddar
MVP Esteemed Contributor

First, You could Select by Attribute where

[FIELDNAME] < 0

Once selected, you could replace the corresponding values with 0 using Field Calculator.



Think Location

View solution in original post

2 Replies
JayantaPoddar
MVP Esteemed Contributor

First, You could Select by Attribute where

[FIELDNAME] < 0

Once selected, you could replace the corresponding values with 0 using Field Calculator.



Think Location
HectorBorro1
Occasional Contributor

aha! many thanks, how can we forget the magical Select?

0 Kudos