Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |