Boolean switch from 1/0 to 0/1

Question

I quite often use a formula like:

Click to copy

=1*(A2=G2)

If A2 and G2 are the same then it returns 1 - otherwise it returns 0.

I realise it is trivial with an IF function but I'm specifically interested in this format of function using 1*.

How can I amend it so that if A2 and G2 are NOT the same it returns 1, otherwise 0?

Answer 1

Use the <> operator to check inequality:

Click to copy

=1*(A2<>G2)

Answer 2

You can just subtract the result from 1, to invert it

Click to copy

=1-1*(A2=G2)