Brian Dunning's FileMaker Custom Functions

ROUNDUP ( number ; decimals )

Replicates the ROUNDUP function from Excel

  Average rating: 4.6 (27 votes) Log in to vote

Jorge Kluchnik   Jorge Kluchnik

Share on Facebook Share on Twitter

  Sample input:
ROUNDUP ( 123.411 ; 2 )
  Sample output:
123.42

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

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

 

Comments

comment   comment, VR
Dec 16, 2011
Why not simply make factor = 10^decimals.
 
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.
 

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.

Under construction. Email me your wish list for improvements.