FractionReduce ( fraction )

Takes string representing fraction and reduces it to most simple form.

Average rating: 4.3 (29 votes) Log in to vote

Brett Buchmiller
None
www.filemaker.com

Sample input:

FractionReduce( "4/8" ; "I" )

FractionReduce( "3 4/12" ; "I" )

FractionReduce( "3 4/12" ; "M" )

Sample output:

"1/2"

"10/3"

"3 1/3"

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

/*
Reduce and format fraction presented in text format.
Required supporting functions:
	FractionType
	FractionNumerator
	FractionDenominator
	GCF
Format = "M" for mixed fraction, "I" for improper
© Brett Buchmiller 10-2011
*/

Let(
[	FType = FractionType ( Input ) ;
	Numerator = If( FType ≠ "Invalid" ; FractionNumerator ( Input ) ; "" ) ;
	Denominator = If( Ftype ≠ "Invalid" ; FractionDenominator ( Input ) ; " " ) ;
	GCFResult = If( not IsEmpty( Numerator ) ; GCF ( Numerator ; Denominator ) ; "" ) ;
	ReducedNumerator = Numerator / GCFResult ;
	ReducedDenominator = Denominator / GCFResult ;
	WholeNumber = If( not IsEmpty( Numerator ) and ReducedNumerator > ReducedDenominator ; Int( ReducedNumerator / ReducedDenominator ) ; "" ) ;
	Remainder =  If( not IsEmpty( WholeNumber ) ; ReducedNumerator - ( WholeNumber * ReducedDenominator ) )
] ;

Case(
	FType = "Invalid" ; "Invalid Input" ;
	Format = "M" or IsEmpty( Format ) ;
		If( not IsEmpty( WholeNumber ) ;
			If( Remainder ≠ 0 ;
				WholeNumber & " " & Remainder & "/" & ReducedDenominator ;
				GetAsText( WholeNumber )
			) ;
			If( ReducedDenominator = 1 ;
				ReducedNumerator ;
				ReducedNumerator & "/" & ReducedDenominator
			) 
		) ;
	Format = "I" ; If( ReducedDenominator = 1 ;
				ReducedNumerator ;
				ReducedNumerator & "/" & ReducedDenominator
			) 
) 
)

Takes string representing a fraction and reduces it using GCF function. Will output string as either mixed number or improper fraction based on flag. Part of a library of fraction functions as mentioned in the comments of function.

Comments

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

FractionReduce ( fraction )

Comments

Support this website.

Support this website.