shortcut to a function?

S

SusanR

I have noticed in a few posts now that -- is used in some of the solutions to
the questions asked eg

=COUNT(--(ROW(1:360)>0))

My question is, what does the -- mean?
 
J

Jack Sons

Bob,

Without the >0 the formula gives 1 as a result, no matter wether it has
1:360 or 1:36.
I would say in all cases it does nothing, but what causes the 1 as a result?

Jack Sons
The Netherlands
 
S

SusanR

The link you gave explained the question thanks.

The formula itself was just an example taken from another post elsewhere in
the forum, it wasn't necessarily a correct formula.
 
B

Bob Phillips

It's an array formula Jack, and it retunes 360 with or without >0 as long as
you array enter it.
 
Top