I quite often use a formula like: <pre class="prettyprint"><code>=1*(A2=G2) </code></pre> If A2 and G2 are the same then it returns <code>1</code> - otherwise it returns <code>0</code>. I realise it is trivial with an <code>IF</code> function but I'm specifically interested in this format of function using <code>1*</code>. How can I amend it so that if A2 and G2 are NOT the same it returns <code>1</code>, otherwise <code>0</code>?

Use the <code><></code> operator to check inequality: <pre class="prettyprint"><code>=1*(A2<>G2) </code></pre>

You can just subtract the result from 1, to invert it <pre class="prettyprint"><code>=1-1*(A2=G2) </code></pre>

Boolean switch from 1/0 to 0/1

I quite often use a formula like:

=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?

808

asked Dec 10 '22 20:12

Use the <> operator to check inequality:

=1*(A2<>G2)

116

answered Dec 25 '22 16:12

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

=1-1*(A2=G2)

answered Dec 25 '22 14:12

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!