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,
--
Joe

VBA Automation/VB/C++/Web and DB development

Check out

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

In article ,
Joe wrote:

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)

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

"JE McGimpsey" wrote:

Check out

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

In article ,
Joe wrote:

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)

Agreed! I didn't understand this either.

/Fredrik


"Duke Carey" wrote in message
...
Great explanation! It helped me go from completely clueless to .. having
SOME understanding

"JE McGimpsey" wrote:

Check out

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

In article ,
Joe wrote:

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)