Shopping Cart

Free Newsletter
Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

FileMaker Pro Custom Functions

List | Show Random | Upload | Add This to Your Site

DecimalToFraction ( number )

Rate this function:

Average rating: 4.0 (13 votes)
Discuss this Custom Function

Michael Myett, FileMaker Apps
http://filemakerapps.biz

convert decimal numbers to fractions

Sample Input:

DecimalToFraction ( 5.75 )

Sample Output:

5 3/4

Case(GetAsNumber ( number ) = Int(GetAsNumber ( number )); Int(GetAsNumber ( number )); GetAsNumber ( number ) < 1; Round((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * (Case(Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 2; 1) = 0; 2; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 3; 1) = 0; 3; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 4; 1) = 0; 4; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 5; 1) = 0; 5; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 6; 1) = 0; 6; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 7; 1) = 0; 7; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 8; 1) = 0; 8; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 9; 1) = 0; 9; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 10; 1) = 0; 10; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 11; 1) = 0; 11; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 12; 1) = 0; 12; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 13; 1) = 0; 13; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 14; 1) = 0; 14; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 15; 1) = 0; 15; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 16; 1) = 0; 16; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 17; 1) = 0; 17; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 18; 1) = 0; 18; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 19; 1) = 0; 19; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 20; 1) = 0; 20; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 21; 1) = 0; 21; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 22; 1) = 0; 22; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 23; 1) = 0; 23; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 24; 1) = 0; 24; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 25; 1) = 0; 25; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 26; 1) = 0; 26; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 27; 1) = 0; 27; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 28; 1) = 0; 28; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 29; 1) = 0; 29; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 30; 1) = 0; 30; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 31; 1) = 0; 31; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 32; 1) = 0; 32; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 33; 1) = 0; 33; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 34; 1) = 0; 34; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 35; 1) = 0; 35; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 36; 1) = 0; 36; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 37; 1) = 0; 37; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 38; 1) = 0; 38; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 39; 1) = 0; 39; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 40; 1) = 0; 40; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 41; 1) = 0; 41; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 42; 1) = 0; 42; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 43; 1) = 0; 43; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 44; 1) = 0; 44; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 45; 1) = 0; 45; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 46; 1) = 0; 46; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 47; 1) = 0; 47; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 48; 1) = 0; 48; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 49; 1) = 0; 49; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 50; 1) = 0; 50; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 51; 1) = 0; 51; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 52; 1) = 0; 52; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 53; 1) = 0; 53; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 54; 1) = 0; 54; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 55; 1) = 0; 55; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 56; 1) = 0; 56; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 57; 1) = 0; 57; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 58; 1) = 0; 58; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 59; 1) = 0; 59; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 60; 1) = 0; 60; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 61; 1) = 0; 61; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 62; 1) = 0; 62; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 63; 1) = 0; 63; 64));0) & "/" & (Case(Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 2; 1) = 0; 2; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 3; 1) = 0; 3; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 4; 1) = 0; 4; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 5; 1) = 0; 5; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 6; 1) = 0; 6; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 7; 1) = 0; 7; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 8; 1) = 0; 8; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 9; 1) = 0; 9; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 10; 1) = 0; 10; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 11; 1) = 0; 11; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 12; 1) = 0; 12; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 13; 1) = 0; 13; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 14; 1) = 0; 14; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 15; 1) = 0; 15; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 16; 1) = 0; 16; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 17; 1) = 0; 17; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 18; 1) = 0; 18; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 19; 1) = 0; 19; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 20; 1) = 0; 20; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 21; 1) = 0; 21; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 22; 1) = 0; 22; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 23; 1) = 0; 23; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 24; 1) = 0; 24; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 25; 1) = 0; 25; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 26; 1) = 0; 26; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 27; 1) = 0; 27; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 28; 1) = 0; 28; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 29; 1) = 0; 29; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 30; 1) = 0; 30; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 31; 1) = 0; 31; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 32; 1) = 0; 32; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 33; 1) = 0; 33; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 34; 1) = 0; 34; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 35; 1) = 0; 35; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 36; 1) = 0; 36; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 37; 1) = 0; 37; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 38; 1) = 0; 38; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 39; 1) = 0; 39; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 40; 1) = 0; 40; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 41; 1) = 0; 41; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 42; 1) = 0; 42; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 43; 1) = 0; 43; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 44; 1) = 0; 44; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 45; 1) = 0; 45; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 46; 1) = 0; 46; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 47; 1) = 0; 47; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 48; 1) = 0; 48; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 49; 1) = 0; 49; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 50; 1) = 0; 50; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 51; 1) = 0; 51; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 52; 1) = 0; 52; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 53; 1) = 0; 53; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 54; 1) = 0; 54; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 55; 1) = 0; 55; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 56; 1) = 0; 56; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 57; 1) = 0; 57; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 58; 1) = 0; 58; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 59; 1) = 0; 59; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 60; 1) = 0; 60; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 61; 1) = 0; 61; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 62; 1) = 0; 62; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 63; 1) = 0; 63; 64)); Int(GetAsNumber ( number )) & " " & Round((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * (Case(Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 2; 1) = 0; 2; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 3; 1) = 0; 3; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 4; 1) = 0; 4; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 5; 1) = 0; 5; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 6; 1) = 0; 6; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 7; 1) = 0; 7; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 8; 1) = 0; 8; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 9; 1) = 0; 9; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 10; 1) = 0; 10; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 11; 1) = 0; 11; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 12; 1) = 0; 12; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 13; 1) = 0; 13; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 14; 1) = 0; 14; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 15; 1) = 0; 15; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 16; 1) = 0; 16; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 17; 1) = 0; 17; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 18; 1) = 0; 18; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 19; 1) = 0; 19; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 20; 1) = 0; 20; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 21; 1) = 0; 21; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 22; 1) = 0; 22; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 23; 1) = 0; 23; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 24; 1) = 0; 24; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 25; 1) = 0; 25; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 26; 1) = 0; 26; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 27; 1) = 0; 27; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 28; 1) = 0; 28; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 29; 1) = 0; 29; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 30; 1) = 0; 30; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 31; 1) = 0; 31; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 32; 1) = 0; 32; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 33; 1) = 0; 33; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 34; 1) = 0; 34; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 35; 1) = 0; 35; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 36; 1) = 0; 36; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 37; 1) = 0; 37; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 38; 1) = 0; 38; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 39; 1) = 0; 39; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 40; 1) = 0; 40; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 41; 1) = 0; 41; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 42; 1) = 0; 42; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 43; 1) = 0; 43; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 44; 1) = 0; 44; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 45; 1) = 0; 45; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 46; 1) = 0; 46; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 47; 1) = 0; 47; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 48; 1) = 0; 48; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 49; 1) = 0; 49; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 50; 1) = 0; 50; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 51; 1) = 0; 51; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 52; 1) = 0; 52; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 53; 1) = 0; 53; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 54; 1) = 0; 54; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 55; 1) = 0; 55; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 56; 1) = 0; 56; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 57; 1) = 0; 57; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 58; 1) = 0; 58; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 59; 1) = 0; 59; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 60; 1) = 0; 60; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 61; 1) = 0; 61; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 62; 1) = 0; 62; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 63; 1) = 0; 63; 64));0) & "/" & (Case(Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 2; 1) = 0; 2; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 3; 1) = 0; 3; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 4; 1) = 0; 4; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 5; 1) = 0; 5; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 6; 1) = 0; 6; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 7; 1) = 0; 7; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 8; 1) = 0; 8; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 9; 1) = 0; 9; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 10; 1) = 0; 10; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 11; 1) = 0; 11; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 12; 1) = 0; 12; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 13; 1) = 0; 13; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 14; 1) = 0; 14; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 15; 1) = 0; 15; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 16; 1) = 0; 16; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 17; 1) = 0; 17; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 18; 1) = 0; 18; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 19; 1) = 0; 19; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 20; 1) = 0; 20; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 21; 1) = 0; 21; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 22; 1) = 0; 22; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 23; 1) = 0; 23; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 24; 1) = 0; 24; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 25; 1) = 0; 25; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 26; 1) = 0; 26; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 27; 1) = 0; 27; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 28; 1) = 0; 28; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 29; 1) = 0; 29; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 30; 1) = 0; 30; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 31; 1) = 0; 31; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 32; 1) = 0; 32; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 33; 1) = 0; 33; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 34; 1) = 0; 34; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 35; 1) = 0; 35; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 36; 1) = 0; 36; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 37; 1) = 0; 37; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 38; 1) = 0; 38; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 39; 1) = 0; 39; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 40; 1) = 0; 40; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 41; 1) = 0; 41; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 42; 1) = 0; 42; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 43; 1) = 0; 43; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 44; 1) = 0; 44; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 45; 1) = 0; 45; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 46; 1) = 0; 46; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 47; 1) = 0; 47; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 48; 1) = 0; 48; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 49; 1) = 0; 49; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 50; 1) = 0; 50; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 51; 1) = 0; 51; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 52; 1) = 0; 52; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 53; 1) = 0; 53; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 54; 1) = 0; 54; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 55; 1) = 0; 55; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 56; 1) = 0; 56; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 57; 1) = 0; 57; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 58; 1) = 0; 58; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 59; 1) = 0; 59; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 60; 1) = 0; 60; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 61; 1) = 0; 61; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 62; 1) = 0; 62; Mod((GetAsNumber ( number ) - Int(GetAsNumber ( number ))) * 63; 1) = 0; 63; 64)))
Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

Since there are not any native conversion functions for decimals to fractions in FileMaker, variations of this lengthy calculation have been used for as long as FileMaker itself.

With custom functions, we can turn this mess into a simple one variable function.

An example might be an auto-enter calculation in the quantity field of a recipe database.

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

This is my Custom Function and I want to edit it

Discuss:

Thanks! Exactly what I'm looking for.

Denise, Boston
June 13, 2010 10:28am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1.	list.intersect (listA; listB)
	(Mon, May 14, 12:43pm)
2.	WeekStart ( weekOfYear ; year )
	(Sat, May 12, 8:42am)
3.	PercentToWords (FIELD)
	(Thu, May 10, 3:16pm)
4.	PercentToText (FIELD)
	(Thu, May 10, 2:37pm)
5.	StripReserved( text )
	(Wed, May 02, 6:05pm)
6.	ListBaseTables
	(Wed, May 02, 3:48pm)
7.	ValidEmail( theEmail )
	(Wed, May 02, 7:27am)
8.	UltraDate (Text; LongDate_or_DateDigit)
	(Wed, May 02, 6:07am)


			[ Close Window ]
	The class that teaches you how to successfully sell your FileMaker Pro solution as a professional shrinkwrapped software application.
	Let's Meet in Person Sunday, August 13 2006, Orlando FL Courtyard Orlando International Drive
	Don't miss this most important day of the Developer Conference. Please click here for complete details and online registration.

FileMaker Pro Custom Functions

Description:

Discuss:

Let's Meet in Person