PercentToWords ( FIELD )

Converts percent number into words suitable for real estate leases, etc.

Average rating: 3.9 (43 votes) Log in to vote

Randy Fowler - Show more from this author

Sample input:

PercentToWords ( 123.04 )

Sample output:

One Hundred and Twenty-Three and 04/100 (123.04%) percent

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

If ( FIELD = 0; "" ; 

Choose ( Int ( Mod ( FIELD;10^3 ) / 100 ) ; ""; "One Hundred "; "Two
Hundred "; "Three Hundred "; "Four Hundred "; "Five Hundred "; "Six
Hundred "; "Seven Hundred "; "Eight Hundred "; "Nine Hundred " ) 
 
& Case ( Int ( Mod ( FIELD;10^3 ) / 100 ) >0 and Int ( FIELD / 10 ) >0;"and ";"" ) 

&

If ( Int ( Mod ( FIELD;100 ) / 10 ) = 1;

Choose ( Int ( Mod ( FIELD;10 ) ) ; "Ten "; "Eleven "; "Twelve ";
"Thirteen "; "Fourteen "; "Fifteen "; "Sixteen "; "Seventeen ";
"Eighteen "; "Nineteen " ) ;
Choose ( Int ( Mod ( FIELD;100 ) / 10 ) ; ""; ""; "Twenty"; "Thirty";
"Forty"; "Fifty"; "Sixty"; "Seventy"; "Eighty"; "Ninety" ) &
	If ( Int ( Mod ( FIELD;100 ) / 10);  "-" ; "" ) &
Choose ( Int ( Mod ( FIELD;10 ) ) ; ""; "One "; "Two "; "Three "; "Four
"; "Five "; "Six "; "Seven "; "Eight "; "Nine " ) ) 

  &

If ( Mod ( FIELD; 1 ) and Int ( FIELD ) ;"and ";"" ) 

&

Case ( Mod ( Int ( FIELD*10 ) ; 10 ) = 1;
	Choose ( Mod ( Int ( FIELD*100 ) ; 10 ) ; "10"; "11"; "12";
	"13"; "14"; "15"; "16"; "17"; "18"; "19" ) ;
          Mod ( Int ( FIELD*10 ) ; 10 )  >  1 ;
	Choose ( Mod ( Int ( FIELD*10 ) ; 10 ) ; ""; ""; "2"; "3";
	"4"; "5"; "6"; "7"; "8"; "9" ) 
	&
	Choose ( Mod ( Int ( FIELD*100 ) ; 10 ) ; ""; "1"; "2"; "3";
	"4"; "5"; "6"; "7"; "8"; "9" ) ;
          Mod ( Int ( FIELD*10 ) ; 10 )  < 1 ;
	Choose ( Mod ( Int ( FIELD*10 ) ; 10 ) ; ""; ""; "2"; "3";
	"4"; "5"; "6"; "7"; "8"; "9" ) 
	& "0" &
	Choose ( Mod ( Int ( FIELD*100 ) ; 10 ) ; ""; "1"; "2"; "3";
	"4"; "5"; "6"; "7"; "8"; "9" ) ;

 ) 

&
Case ( Mod ( FIELD; 1 ) > .01; "/100 (" & FIELD & "%) percent" ; Mod ( FIELD; 1 ) = .01; "/100 (" & FIELD & "%) percent" ; "" ) 

 )

Revised Version (accounts for first decimal place of 0): Converts a numbered percent into words suitable for real estate leases, etc.

Comments

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

PercentToWords ( FIELD )

Comments

Support this website.

Support this website.