View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Sullentrup Bob Sullentrup is offline
external usenet poster
 
Posts: 25
Default --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.