开发者

What does <> mean in excel? [duplicate]

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜