--alpha = 0.10, alpha = 0.05, and/or
 

I just typed that --alpha = 0.10, alpha = 0.05, and/or into a cell and
noticed that XL thinks I'm trying to type a formula.

When/why would you begin a formula with -- ?

I know -- can be used with SUMPRODUCT and other functions, but as the
beginning of a function??

And yes I know I can fix this by putting an apostrophe to the left. I just
don't get what XL is thinking here...

Dave


--
Brevity is the soul of wit.

--alpha = 0.10, alpha = 0.05, and/or
 

Methinks XL is thinking negative negative, thus positive.

--
Bob Sullentrup


"Dave F" wrote:

I just typed that --alpha = 0.10, alpha = 0.05, and/or into a cell and
noticed that XL thinks I'm trying to type a formula.

When/why would you begin a formula with -- ?

I know -- can be used with SUMPRODUCT and other functions, but as the
beginning of a function??

And yes I know I can fix this by putting an apostrophe to the left. I just
don't get what XL is thinking here...

Dave


--
Brevity is the soul of wit.

--alpha = 0.10, alpha = 0.05, and/or
 

It is treating alpha as an Excel defined name because it is preceded by an
operator (-- is just twice of -), so it thinks it is a formula. -alpha, +
alpha does the same.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Dave F" wrote in message
...
I just typed that --alpha = 0.10, alpha = 0.05, and/or into a cell and
noticed that XL thinks I'm trying to type a formula.

When/why would you begin a formula with -- ?

I know -- can be used with SUMPRODUCT and other functions, but as the
beginning of a function??

And yes I know I can fix this by putting an apostrophe to the left. I
just
don't get what XL is thinking here...

Dave


--
Brevity is the soul of wit.

--alpha = 0.10, alpha = 0.05, and/or
 

BTW, -- is not specific to SUMPRODUCT, type this
=IF(--"2006-11-28"=TODAY(),"Yes","No") and see.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Dave F" wrote in message
...
I just typed that --alpha = 0.10, alpha = 0.05, and/or into a cell and
noticed that XL thinks I'm trying to type a formula.

When/why would you begin a formula with -- ?

I know -- can be used with SUMPRODUCT and other functions, but as the
beginning of a function??

And yes I know I can fix this by putting an apostrophe to the left. I
just
don't get what XL is thinking here...

Dave


--
Brevity is the soul of wit.

--alpha = 0.10, alpha = 0.05, and/or
 

Interesting.

The things you learn.

Dave
--
Brevity is the soul of wit.


"Bob Phillips" wrote:

It is treating alpha as an Excel defined name because it is preceded by an
operator (-- is just twice of -), so it thinks it is a formula. -alpha, +
alpha does the same.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Dave F" wrote in message
...
I just typed that --alpha = 0.10, alpha = 0.05, and/or into a cell and
noticed that XL thinks I'm trying to type a formula.

When/why would you begin a formula with -- ?

I know -- can be used with SUMPRODUCT and other functions, but as the
beginning of a function??

And yes I know I can fix this by putting an apostrophe to the left. I
just
don't get what XL is thinking here...

Dave


--
Brevity is the soul of wit.