User Tools

Site Tools


syntax:functions:round

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
syntax:functions:round [2016/07/08 00:10] dmitrysyntax:functions:round [2016/07/09 08:44] dmitry
Line 3: Line 3:
 Rounds a number to N decimal digits.  Rounds a number to N decimal digits. 
  
-Note: there exist two types of rounding in general -- "Rounding away from zero" (a.k.a symmetric rounding) and "Rounding to the nearest even number" (a.k.a. banker's rounding). While "Rounding away from zero" is used in Excel for historical reasons, the standard way is to use "Rounding to the nearest even number" as described in IEEE Standard 754, section 4. EasyMorph follows this standard.+Note: there exist two types of rounding in general -- "Rounding away from zero" (a.k.a symmetric rounding) and "Rounding to the nearest even number" (a.k.a. banker's rounding). This function is using the latteras it'the standard way of rounding as described in IEEE Standard 754, section 4. For Excel-type rounding (away from zero) use [syntax:functions:roundxl] function.
  
 ^  Example  ^  Result  ^ ^  Example  ^  Result  ^
Line 13: Line 13:
   * [[syntax:functions:floor]]   * [[syntax:functions:floor]]
   * [[syntax:functions:ceiling]]   * [[syntax:functions:ceiling]]
 +  * [[syntax:functions:roundxl]]
syntax/functions/round.txt · Last modified: 2023/02/28 20:13 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki