FLOAT.TO.BIN
Converts a floating point number to binary. Floating point numbers are represented as a 32bit-IEEE-754 number.
Syntax
=FLOAT.TO.BIN(Number)
Arguments
| Name | Type | Description |
|---|---|---|
| Number | Number | The floating point number to convert. |
Return
| Type | Description |
|---|---|
| Number or Error | The binary number or a #NUM! error if given number is not a valid floating point number. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 01000000001001000100100110111010 | converts floating point 2.567 to binary |