Excel Inequalities: "<>" vs "><"


Joined
Dec 2, 2017
Messages
1
Reaction score
0
I cannot find any documentation around the difference between "<>" (not equal to) and "><" used in a formula. The latter is in theory not allowed and in a simple formula returns an error or an incorrect value. However, I discovered in a formula that needed to filter out blank cells from an Excel table, the only way I could get the correct result was to use "><" rather than "<>". Has anyone encountered this and can explain it?
 
Ad

Advertisements


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

Top