RoundToEven ( number ; precision )

Rounds number to specified precision, using the round-to-even rule - also known as Bankers' rounding.

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

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

RoundToEven ( 0.5 ; 0 )
RoundToEven ( 1.5 ; 0 )

RoundToEven ( 0.045 ; 2 )
RoundToEven ( 0.055 ; 2 )

Sample output:

0
2

0.04
0.06

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

/*
RoundToEven function

Author
*COMMENT Visual Realisation

Format
RoundToEven ( number ; precision )

Parameters
number - any numeric expression or field containing a numeric expression

precision - any numeric expression or field containing a numeric expression

Data type returned
number

Description
Rounds number to specified precision, using the round-to-even rule - also known as Bankers' rounding.

January 25, 2006
*/

Let ( [
rem = Mod ( number * 10^precision ; 1 ) ;
prev = Mod ( Int ( number * 10^precision ) ; 10 ) 
] ;
Case ( 
rem = 0.5 and not Mod ( prev ; 2 ) ; 
Truncate ( number ; precision ) ; 
Round ( number ; precision ) 
)
)

For a detailed explanation of the round-to-even rule (Bankers' rounding), see
http://en.wikipedia.org/wiki/Significance_arithmetic#The_round-to-even_rounding_rule

This function is not recursive.

Comments

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

RoundToEven ( number ; precision )

Comments

Support this website.

Support this website.