According to the relevant Microsoft Support page on the BITAND function, I should have access to it, as I am running Excel for Mac 2011 (with the latest updates installed):
"APPLIES TO: Excel 2016, Excel 2013, Excel 2016 for Mac, Excel for Mac 2011",
When when I try to use it, e.g. by entering "=BITAND(127,8)" I get the dreaded "#NAME?", showing that it is not in fact recognized. It does not appear as an auto-complete option while typing, in fact entering just "=BIT" generates no autocomplete suggestions.
The Microsoft Support page doesn't say anything about needing to install additional add-in packages, although I know that's sometimes an issue. (Note: apparently it was required in 2008 as this link suggests, but nothing for the 2011 version.)
Can anyone offer a suggestion to get this working?
Alternatively, I just want to obtain a decimal-to-binary conversion but unlike DEC2BIN I don't want a string of 1's and 0's in the same cell, rather I want each bit value to end up in its own cell. Perhaps parsing the DEC2BIN string would get the job done.