Massimo,

the -- is called a unary minus and used to force a conversion from
booleans to numbers. Many array oriented functions work better with
numbers than with booleans and the guru's have found it faster than n().

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


max wrote :

Hi all,

does anybody know the meaning of "--" in a formula?

for example:
=IF(SUMPRODUCT(--(B4:B5=B5))=1;1;0)


thanks a lot!
Massimo