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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks