Is there any way to add binary numbers and inverse them using excel?
Announcement
Collapse
No announcement yet.
Excel and Binary numbers
Collapse
X

I've been doing a lot with binaries lately. I've been converting the base ten numbers to binary using dec2bin or some sort of looping function for conversion (tell me if you want the code). And then, since I've found that Excel can't handle numbers with more than 15 digits in them without forgetting the last few, I convert the binary string to an array. If you have two arrays, you should then be able to add them together, carry the two's, and manipulate however you wish. After that, it's fairly simple to convert back to base ten.
Kabong
Comment
Comment