If Statement with -1

[Uri]

Hi!

Can anyone explain why I get 0 instead of -1?

Script:

=If(FIELD1 <= FIELD2 , FIELD3 = '-1',  FIELD3)

Instead of -1 it shows 0 as a result.

BR,

Uri

[jwjackso · Accepted solution]

FIELD3='-1' is a comparison , not an assignment.  

[Uri]

Thanks @jwjackso  for the reply.

I used follows and it works now.

Thanks!