79557290

Date: 2025-04-05 17:10:20
Score: 3
Natty:
Report link

How can d162c240 or c240d162 be 6.07456254959106 if the most significant bit is active, meaning it has a negative number?

My formula (change ‘x’ to the required cell): =(-1)^(BITAND(HEX2DEC(x);HEX2DEC("80000000"))/2^31) * (1 + BITAND(HEX2DEC(x);HEX2DEC("007FFFFF"))/2^23) * 2^(BITAND(HEX2DEC(x);HEX2DEC("7F800000"))/2^23-127)

Reasons:
  • No code block (0.5):
  • Contains question mark (0.5):
  • Unregistered user (0.5):
  • Starts with a question (0.5): How can
  • Low reputation (1):
Posted by: CUE