Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does <> mean in excel? [duplicate]

Tags:

excel

Google doesn't understand <> so that failed thus asking here.

What does '<>' (less than followed by greater than) mean in Excel? For example:

=SUMPRODUCT((E37:N37>0)*(E37:N37<>"")*(E37:N37))

What's happening here?

like image 201
aateeque Avatar asked Jul 09 '11 13:07

aateeque


1 Answers

It means "not equal to" (as in, the values in cells E37-N37 are not equal to "", or in other words, they are not empty.)

like image 154
James Allardice Avatar answered Sep 24 '22 21:09

James Allardice