开发者

What does <> mean in excel? [duplicate]

开发者 https://www.devze.com 2023-03-18 06:17 出处:网络
This question already has answers here: What does <> mean? (5 answers) Closed 8 years ago. Google doesn\'t understand <> so that failed thus asking here.
This question already has answers here: What does <> mean? (5 answers) Closed 8 years ago.

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?


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.)

0

精彩评论

暂无评论...
验证码 换一张
取 消