How can I perform calculations with hexadecimals

[Guest]

Has anyone ever had to do this on a spreadsheet?

 

[Gord Dibben]

Check out Help on HEX2DEC.

You would convert to Decimal then do your calculations.

Need the Analysis ToolPak loaded.


Gord Dibben MS Excel MVP