Thread: What is the "--" (double dash) in MS Excel formula?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default What is the "--" (double dash) in MS Excel formula?
On Sun, 4 Aug 2013 15:34:35 -0700, joeu2004 wrote:
Normally, double-negation is needed to convert non-numeric values to numeric
values. Any idempotent arithmetic operation will work; for example,
multiplying by 1 instead of using double-negation. (But I prefer
double-negation.)


Out of curiosity, why? How is that superior to multiplying by 1 or
adding 0?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
Reply With QuoteReply With Quote