It can convert text numbers to number numbers, too.

But in this case, it's used to convert True/False to 1/0.



windsurferLA wrote:

Update... I now see that unary operator, --, is to prevent #ERROR valves
from stopping the process.

WindsurferLA

windsurferLA wrote:
In your message you showed the expression B4 =--(B2)

I've seen the double dash or double negative signs elsewhere. Does it
have a meaning other than that of applying the negation twice?

WindsurferLA


Bernard Liengme wrote:

When you do an arithmetic operation on Boolean values (or on text
values that represents digits), Excel converts the Boolean (text) to a
number.
Try this:
A1 = apple
B1 =apple
B2 =B1=A1
B3 = B2*1
B4 =--(B2)
B5 =B2+7

D1 =happy2005
D2 =LEFT(D1,5)&RIGHT(D1,4)+1)

best wishes

--

Dave Peterson