topic Re: Calculate field using IF in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/calculate-field-using-if/m-p/123763#M448 <HTML><HEAD></HEAD><BODY><P>First, You could <STRONG>Select by Attribute</STRONG> where</P><P><EM>[FIELDNAME] &lt; 0</EM></P><P>Once selected, you could replace the corresponding values with 0 using Field Calculator.</P></BODY></HTML> Tue, 12 Jul 2016 19:40:04 GMT JayantaPoddar 2016-07-12T19:40:04Z Calculate field using IF https://community.esri.com/t5/arcgis-mapping-and-charting-questions/calculate-field-using-if/m-p/123762#M447 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P>I have a list of polygons that have values from -140 to +1 where the negatives are outliers and should have value = 0 </P><P>How can I calculate a value using IF statement? Having some trouble with Python as it is new for me... </P><P>In excel the formula would be: =if(A1&lt;0,0,A1)</P><P>How can I achieve this in ArcGIS pro v 1.2?</P></BODY></HTML> Tue, 12 Jul 2016 17:14:43 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/calculate-field-using-if/m-p/123762#M447 HectorBorro1 2016-07-12T17:14:43Z Re: Calculate field using IF https://community.esri.com/t5/arcgis-mapping-and-charting-questions/calculate-field-using-if/m-p/123763#M448 <HTML><HEAD></HEAD><BODY><P>First, You could <STRONG>Select by Attribute</STRONG> where</P><P><EM>[FIELDNAME] &lt; 0</EM></P><P>Once selected, you could replace the corresponding values with 0 using Field Calculator.</P></BODY></HTML> Tue, 12 Jul 2016 19:40:04 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/calculate-field-using-if/m-p/123763#M448 JayantaPoddar 2016-07-12T19:40:04Z Re: Calculate field using IF https://community.esri.com/t5/arcgis-mapping-and-charting-questions/calculate-field-using-if/m-p/123764#M449 <HTML><HEAD></HEAD><BODY><P>aha! many thanks, how can we forget the magical <STRONG>Select</STRONG>?</P></BODY></HTML> Tue, 12 Jul 2016 21:00:13 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/calculate-field-using-if/m-p/123764#M449 HectorBorro1 2016-07-12T21:00:13Z