Limitations of excel functions?

[ally200]

Just need 2 kmow some Limitations of excel functions.
Using:
BIN2DEC - Converts a binary number to a decimal
OCT2DEC - Converts octal number to a decimal
OCT2HEX - Converts octal number to hexadecimal
BIN2HEX - Converts a binary number to hexadecimal
HEX2DEC - Converts a hexadecimal number to a decimal
HEX2OCT - Converts a hexadecimal number to octal
OCT2BIN - Converts octal number to binary
BIN2OCT - Converts a binary number to octal
DEC2BIN - Converts a decimal number to binary
DEC2HEX - Converts a decimal number to hexadecimal
DEC2OCT - Converts a decimal number to octal
HEX2BIN - Converts a hexadecimal number to binary

stuff like u cant add in excel when u convert a binary number etc

Ah ye for example when u covert from decmaill 2 binarey right u get like 1011 then u want 2 add 1011 well excel will think its a normal number and the answer will be 2022 when it shouldent be that as i want 2 add 2 binary numbers togther. Thats what i meam

 

[Jonmo1]

Welcome to the board..

to add 2 binary numbers together, I think you would have to
use bin2dec on each binary number seperately.
Then use dec2bin on those results...

Like
A1 = 1011
B1 = 1011
C1: =DEC2BIN(BIN2DEC(A1)+BIN2DEC(B1)) = 10110