The difference between = and <>?

G

Gunjani

In formulation can someone explain the difference between = sign and <>
sign e.g as in =SUMPRODUCT((A1:A100="E"),(A2:A101<>"L"))
compared to =SUMPRODUCT((A1:A100="E"),(A2:A101="L"))

I tried it out and saw the difference but could not understand the
difference in order to use it in another criteria.
 
B

Bernard Liengme

Firstly you should use SUMPRODUCT(--(A1:A100="E"),--(A2:A101<>"L")) where
the double negation converts Boolean TRUE and FALSE values to the numeric
values 1 and 0.

The symbol = in A1:A100="E" tests to see if the values are EQUAL to the
letter E
The symbol <> in A2:A101<>"L" test to see if the value are NOT EQUAL to the
letter "L"

You can real <> as meaning "larger or smaller than" - same as not equal to!

Best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference Between Highest And Lowest? 4
Cobining various numbers of cells without using the & or concatena 2
% Difference between cells based on variable... 3
Pivot tables calculated fields 2
Difference Between "--" and "*" in Sumproduct 3
Strange date problem with autofill 1
Searching for a word and then copy the whole row 5
Difference between two times in seconds 1

Top