Formula tool issue

[SDeora]

Hello, I am using Formula tool to replace values in a range with 0.00. In case the initial value is already 0.00 result is turning out to be -1.00 instead of 0.00. 

How can I fix this? 

Pre:

Formula: if [Field2]<=20.00 AND [Field2]>=-20.00 THEN [Field2]=0.00 ELSE [Field2] ENDIF

Post: notice record 6 was already 0.00 and formula tool replaced it with -1.00

Attached workflow. Please help!! 

[JosephSerpis · Accepted solution]

Hi @SDeora your syntax of the formula should be "if [Field2]<=20.00 AND [Field2]>=-20.00 THEN 0.00 ELSE [Field2] ENDIF"

[SDeora]

This worked great. Thank you !!