-(减号)在Excel中是做什么的? [英] What does -- (minus minus) do in Excel?

问题描述

在Excel中，我有两个单元格

In Excel I have two cells

A1 Gwen Stefani
B1 =SUMPRODUCT(--(A1:A10="Gwen Stefani"))

B1记录的值为1(在单元格A1中计数为"Gwen Stefani")

B1 records a value of 1 (it counts "Gwen Stefani" in cell A1)

我的问题是这样的:-想要一个更好的词，-运算符叫什么?

My question is this: What is the -- operator called, for want of a better word, and what does it do?

• 在Excel帮助中自然查找-"可得到50,200个结果-这无济于事;)

推荐答案

(A1:A10 ="Gwen Stefani")的结果为一个数组(TRUE，FALSE，FALSE，FALSE ...).因此，您将其乘以1得到(1,0,0，...).可以用相同的结果将--"替换为"1 *".

The (A1:A10="Gwen Stefani") evaluates to an array (TRUE, FALSE, FALSE, FALSE...). So you are multiplying it by 1 to get (1,0,0,...). The "- -" can be replaced by "1*" with the same result.

这篇关于-(减号)在Excel中是做什么的?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！