Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

DecimalToFraction ( number )

convert decimal numbers to fractions

  Average rating: 4.1 (34 votes) Log in to vote

Michael Myett - Show more from this author FileMaker Apps

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

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))) Click to copy

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.

 

Comments

		Denise, Boston Jun 13, 2010
Thanks! Exactly what I'm looking for.

		Kay Fenlason Feb 25, 2023
This does not quite work for a recipe database, I have never used .7 cups of sugar!

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: