Unary operators

J

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

Duke Carey

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
SUMPRODUCT- double unary vs. * 2
Double Equals Operator? 5
Excel calculation error: sometimes ignores unary minus 2
How to make scroll bar permanently visible, Word 365 0
Powerpoint Ink Reacts Different in Different places 0
Calculate the median value before a specified list 0
"not" operator missing in equations for word 2007 5

Top