Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
--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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
--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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
--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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
--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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
--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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|