Goal: Translate between Machine Code (Binary) and Human Numbers (Decimal).
Each bit represents a power of 2. Toggle the switches to see the math.
Ready...
💻 Formula Structure
=BIN2DEC(number)
- Input: A text string of 0s and 1s (e.g., "1101").
- Max: 10 bits (up to 511 decimal).
=DEC2BIN(number, [places])
- Input: An integer (-512 to 511).
- Places: (Optional) Pad with leading zeros (e.g., 8 digits).
-- Convert Binary to Decimal
=BIN2DEC( "00000000" )
⚠️ Limits
🚫 10-Bit Limit
Standard Excel Engineering functions are limited to 10 bits (-512 to 511). For larger numbers, you need custom formulas or VBA.