FracDecToBin ( frac )

Convert a fractional decimal value to a binary fraction.

Average rating: 4.2 (19 votes) Log in to vote

Jake DeGroot - Show more from this author

Sample input:

FracDecToBin ( .625 )
FracDecToBin ( .1 )

Sample output:

.101
.0001100110011001

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
CUSTOM FUNCTION: FracDecToBin ( frac )
© 2016 Jake DeGroot, jakedeg@gmail.com

Convert a fractional decimal value to a binary fraction. 

EXAMPLES:

   FracDecToBin ( .625 ) // --> ".101"
   FracDecToBin ( .1 ) // --> ".0001100110011001"


IMPLEMENTATION: Requires DecToAnyBase: http://www.briandunning.com/cf/218

LAST MODIFIED: 29-MARCH-2016 by Jake DeGroot
*/


Let([
p = Position ( frac ; "." ; 1 ; 1 ); //Find the decimal
x = If ( p ; frac ; "."& frac ); //Add a leading decimal if there isn't one.
m = x*2^100;
bin = DecToAnyBase (Int(m);2);
y = bin/(10^100)
];
y
)

Requires DecToAnyBase: http://www.briandunning.com/cf/218

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

FracDecToBin ( frac )

Comments

Support this website.

Support this website.