You are here

Really cool HEX to signed interger trick in Excel | Cypress Semiconductor

Really cool HEX to signed interger trick in Excel

 

I have been collecting integer data to be processed in Excel I use the function thats sends the data as four HEX bytes. The problem is that is is signed data. The following equation takes 16 bit hex data and converts is to the signed DEC.
 
MOD(HEX2DEC(A7)+2^15,2^16)-2^15;
 
For eight bit data use
MOD(HEX2DEC(A7)+2^7,2^8)-2^7;
 
For 32 bit data

MOD(HEX2DEC(A7)+2^31,2^32)-2^31

I find Excel to be one of the most versital Engineering tools.  It is amzing that a business friend of mind think its a business tool

Dave

ALL CONTENT AND MATERIALS ON THIS SITE ARE PROVIDED "AS IS". CYPRESS SEMICONDUCTOR AND ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THESE MATERIALS FOR ANY PURPOSE AND DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THESE MATERIALS, INCLUDING BUT NOT LIMITED TO, ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT OF ANY THIRD PARTY INTELLECTUAL PROPERTY RIGHT. NO LICENSE, EITHER EXPRESS OR IMPLIED, BY ESTOPPEL OR OTHERWISE, IS GRANTED BY CYPRESS SEMICONDUCTOR. USE OF THE INFORMATION ON THIS SITE MAY REQUIRE A LICENSE FROM A THIRD PARTY, OR A LICENSE FROM CYPRESS SEMICONDUCTOR.

Content on this site may contain or be subject to specific guidelines or limitations on use. All postings and use of the content on this site are subject to the Terms and Conditions of the site; third parties using this content agree to abide by any limitations or guidelines and to comply with the Terms and Conditions of this site. Cypress Semiconductor and its suppliers reserve the right to make corrections, deletions, modifications, enhancements, improvements and other changes to the content and materials, its products, programs and services at any time or to move or discontinue any content, products, programs, or services without notice.