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

G

Guest

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
 
B

Bob Phillips

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

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement for alpha numeric combo AND numeric only 4
compare for high with two or more cells and then flag. 1
Validate Text for Pivot Table Filter 2
Separating Numerical and Alpha Data in cells 6
Removing Trailing Alpha - Something I Forgot 1
Reference to closed workbook 2
How can I pick up characters after the first 4 in Excel cell 6
sumproduct text and numbers same column 2

Top