Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 22nd 05, 08:01 PM posted to microsoft.public.excel.worksheet.functions
Brad
 
Posts: n/a
Default What is the "--" used for - or how do I ask excel for help

There are many formulas that I see that have a "--". What are they used for,
or how do I ask Excel for help to read more about this topic.

Example

=IF(ISERR(--(A1)),LEFT(A1,MATCH(FALSE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LE
N(A1))),1)),0)-1),A1)


  #2   Report Post  
Old November 22nd 05, 08:13 PM posted to microsoft.public.excel.worksheet.functions
Ken Wright
 
Posts: n/a
Default What is the "--" used for - or how do I ask excel for help

You'll find an example he-

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Brad" wrote in message
...
There are many formulas that I see that have a "--". What are they used
for,
or how do I ask Excel for help to read more about this topic.

Example

=IF(ISERR(--(A1)),LEFT(A1,MATCH(FALSE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LE
N(A1))),1)),0)-1),A1)



  #3   Report Post  
Old November 22nd 05, 09:03 PM posted to microsoft.public.excel.worksheet.functions
Sloth
 
Posts: n/a
Default What is the "--" used for - or how do I ask excel for help

Usually that is used instead of the VALUE function. It's a trick that takes
advantage of how Excel interprets text (or workaround depending on how you
think of it). It also can be used for boolean values (true or false). All
of the following result in the same value of 1.

=1
=--"1"
=--TRUE
=VALUE("1")

In your formula you are using the text function MID to extract the middle
number from a string of charectors. This results in a text string that must
then be converted to a number.

"Brad" wrote:

There are many formulas that I see that have a "--". What are they used for,
or how do I ask Excel for help to read more about this topic.

Example

=IF(ISERR(--(A1)),LEFT(A1,MATCH(FALSE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LE
N(A1))),1)),0)-1),A1)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017