Unary operators

[Joe]

I've noticed several posts which use the unary operators "--" before
implementing some function. Why is this done?

Here's an example:

=--(COUNTIF(A1,"CA*")>0)

TIA,

 

[JE McGimpsey]

Check out

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

 

[Duke Carey]

Great explanation! It helped me go from completely clueless to .. having
SOME understanding

 

[Fredrik Wahlgren]

Agreed! I didn't understand this either.

/Fredrik