!= vs. =!

Question

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 Answer

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 Answer

@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.