ExcelBanter - Hexadecimal Calculations

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hexadecimal Calculations (https://www.excelbanter.com/excel-programming/284432-hexadecimal-calculations.html)

jason

Hexadecimal Calculations

I know you can convert numbers to hexadecimal in Excel.
But, can you calculate numbers using hex data without
doing the conversion?

Thanks.

Jason

Tom Ogilvy

Hexadecimal Calculations

from the immediate window:

? &HFF - &HF0
15
? Hex(&HFF - &HF0)
F

Regards,
Tom Ogilvy

"Jason" wrote in message
...
I know you can convert numbers to hexadecimal in Excel.
But, can you calculate numbers using hex data without
doing the conversion?

Thanks.

Jason

All times are GMT +1. The time now is 03:51 PM.