Brian Dunning's FileMaker Custom Functions

ROUNDDOWN ( number ; decimals )

Replicates the ROUNDDOWN function from Excel

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

Jorge Kluchnik   Jorge Kluchnik

Share on Facebook Share on Twitter

  Sample input:
ROUNDDOWN ( 123.416 , 2 )
  Sample output:

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

Replicates the Excel function ROUNDDOWN. Works up to 100 decimals. If you need more, just add more zeros to the ~zeros variable.



comment   comment, VR
Dec 16, 2011
How about =

Let (
magnitude = 10^decimals
Floor ( number * magnitude) / magnitude
Jorge   Jorge, Liechtenstein
Dec 18, 2011
I am so glad that there are so many people out there smarter than me that are wiling to contribute! Leave it to comment. Thanks! I have updated it accordingly.
Bill   Bill, BKK Thailand
Jun 24, 2018
Trying this function with Filemaker Pro Adv.
Error when creating new function..."The specified parameter cant be found" decimals

Let (
magnitude = 10^decimals
Floor ( number * magnitude) / magnitude

Your assistance is appreciated


Log in to post comments.


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

Under construction. Email me your wish list for improvements.