![]() ![]() The problem is almost certainly in the cell with the results having the format of poster is using Excel 2007 and I cannot test in that. When I try to use any other formula, I'm not getting values in hex. I've tried various combinations of formulas and nothing seems to work, however, if I do something simple like set cell D4 equal to B4 using the formula =B4 in cell D4, Excell will display 0x100000 in cell D4. I'm expecting to get 0x100400 as my printed result. However, Excel is printing the text 0x=Sum(HEX2DEC(B4),1024)) in the cell. One would think for cell B5 they would use something like =SUM(HEX2DEC(B4),1024) since B4 is displayed as hex convert 0x100000 to decimal then add 1024 since 1024 in decimal is 0x400 in hex. ![]() BN I'm trying to increment it by 0x400 each time we go down one row. Instead of manually typing in each value into B5, B6. I'm trying to calculate the address values going vertically down in column B. This table has the following custom format I'm trying to do calculations. I'm working on a spread sheet and I have a table or grid of x that looks like this: B c D E F G IYÄ£ Address. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |