bitwise functions
Excel has an OR function and VBA has both OR and XOR but the latter is not
included as a worksheet function but for XOR you can use.
=NOT(A1)+NOT(B1)=1
another XOR
=(A1<0)+(B1<0)=1
I have no idea what 'shift' or etc mean in this context
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"vbano" wrote:
I need bitwise functions for a spreadsheet (shift, OR, XOR, etc). Is there a
way to do this in Excel for example?
|