Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Binary Calculations in Excel

Status
Not open for further replies.
usfwood

usfwood

Technical User
Aug 9, 2001
3
US
How can I do 12bit 2's compliment and hex to binary calculations? Are there any add-ins (beside analysis pack)for performing binary/logical functions?
 
Sort by date Sort by votes
no problem...

there are several functions:

HEXINBIN, BININHEX, etc.

if you don't have them, you have to install the analysis functions (with the add-in-manager), they are free with excel...

greetings

wingster
 
Upvote 0 Downvote
I already have the Analysis Tool Pack Add_In installed. The functions HEX2BIN etc. only allow a max value of 1FFh. I need to be able to process 12bit data (up to FFFh). Also, I could not find any functions to invert, mask, and, or, etc. the binary words either.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
588
remeng
remeng
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
213
sal21
sal21
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
347
huiettcm
huiettcm
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
332
combo
combo
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top