Skip to main content
Version: Streamsheets 2.5

BIN2FLOAT

Converts a binary number to a floating point number. Floating point numbers are represented as a 32bit-IEEE-754 number.

Syntax

=BIN2FLOAT(Number)

Arguments

NameDescription
NumberThe binary number to convert.

Return

The floating point number or a #NUM! error if given number is not a valid binary number.

Examples

FormulaResultComment
=BIN2FLOAT("01000000010010010000111111011011")
3.1415927410125732421875converts binary number 01000000010010010000111111011011 to floating point number