Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

PercentToText ( FIELD )

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

  Average rating: 4.7 (24 votes) Log in to vote

Randy Fowler - Show more from this author

  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 ";"" ) & If ( Mod ( Int ( FIELD*10 ) ; 10 ) = 1; Choose ( Mod ( Int ( FIELD*100 ) ; 10 ) ; "10"; "11"; "12"; "13"; "14"; "15"; "16"; "17"; "18"; "19" ) ; 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" ) ) & Case ( Mod ( FIELD; 1 ) > .01; "/100 (" & FIELD & "%) percent" ; Mod ( FIELD; 1 ) = .01; "/100 (" & FIELD & "%) percent" ; "" ) ) Click to copy

Converts number meant to be a pecentage into text formatted for a real estate lease, etc., Thus 23.42 would become Twenty-Three and 42/100 (123.42%) percent. Function only goes up to 999.99%

 

Comments

		Will Loving, Dedication Technologies, Inc. Feb 6, 2014
The function isn't particularly efficient on the fraction part. It also doesn't handle something like 0.7% correctly as a fraction, converting it to 7/100 instead of 70/100. I would take the last section that deals with the fraction and replace it with this: Right( "00" & Mod( Int( Start amount *100 ) ; 100 ) ; 2 ) the first section could be shortened slightly by taking "Hundred" out from each choice and adding it to the end of the calculation.

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: