!= vs. =!

[FrederikE]

Hey together, 

I just ran into an interesting mistake I just made and am a bit confused about it. 

Typed "=!" instead of "!="

Mod(10,3)!=0 -> TRUE

Mod(10,3)=!0 -> FALSE

What is happening when I type "=!"? 

Thought this would make "equals NOT-zero" instead of "NOT-equals zero", which is logically the same thing, but thats, not the case. 

[ShankerV · Accepted solution]

Hi @FrederikE 

!= Does not equal

=! Boolean NOT !

Here it accepts one input and if that input is TRUE then it will return False.

If the input is False then it return True.

Shanker V

[IraWatt · Accepted solution]

@FrederikE 

Just a guess here, first step is to simplify this to what the formula returns:

1!=0

1=!0

The first compares the number 1 and the number 0 returning the correct answer. The second I think compares the number 1 with 'Not Zero' which is actually interpreted as the Boolean True. So, the second statement really says the number 1 equals True which causes it to say false. 

The formula tool syntax and interpretation has a lot of quirks so this guess could be completely off.

[FrederikE]

Hey @ShankerV , @IraWatt ,

Thanks for your responses. An interesting feature -  seems like a very niche use case where this would be used for just requiring two signs.