What does -(Field='Y') means?

[microwin88x]

I have a field with 2 possible values: Y / N

What does it mean to type -(Field = 'Y') ?

Thanks!

[Anonymous]

if that is within an if statement, then it means you are checking if Field equals Y.

so the following statement in a text box will return "Field is Y" or "Field is N" depending on the selection.

=if(Field = 'Y', 'Field is Y', 'Field is N')

[Gysbert_Wassenaar · Accepted solution]

It will return 1 if the value is Y. (Field = 'Y') will return true if the value of Field is Y and the value of true is -1. By multiplying it with -1, e.g. the minus sign in before the parentheses you get 1.