Logical And &

It seems to think 2 & 4 = 1. when it should be 0. Also it thinks 2 & 6 is 1 when it should be 2. It looks like maybe "logical and" only cares about the first bit.

I'm trying to see if an array of things are on or off with a single number which should be easy with a logical AND. Is there a way to do an actual AND on the numbers?

You're thinking of "bitwise and". "&" in C2 expressions is "logical and" where 0 is false and nonzero is true.

That said you can do "bitwise and" with the browser object and the ExecJS expression.

For example setting some text to Browser.ExecJS("4&2") will give 0.

Perfect thanks!   <img src="smileys/smiley17.gif" border="0" align="middle" />

Yan made a plug.

There's getbit and setbit which I didn't know about at the time... Those do exactly what I was trying to do and they're already system expressions.