I sometimes see a double minus is array formulas like:
=SUMPRODUCT(--($C$2:$C$3=9102);--ISNUMBER(SEARCH("piec";$D$2:$D$3));$F$2:$F$3)
Is this just short for If($C$2:$C$3=9102;1;0) or is there more to it?
I sometimes see a double minus is array formulas like:
=SUMPRODUCT(--($C$2:$C$3=9102);--ISNUMBER(SEARCH("piec";$D$2:$D$3));$F$2:$F$3)
Is this just short for If($C$2:$C$3=9102;1;0) or is there more to it?
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
See if links help explain the double unary operator
http://www.xldynamic.com/source/xld....tml#advantages
http://www.contextures.com/xlFunctions02.html#Trouble
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
THX Noob, The good stuff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks