Manuals/calci/FIXED

From ZCubes Wiki
Revision as of 11:00, 19 November 2013 by Swapna (talk | contribs)
Jump to navigation Jump to search

FIXED(number, decimals)

  • where 'number' is the number to round, and
  • 'decimals' is the number of digits after the decimal point.

FIXED() rounds a number to the specified number of decimals, and displays the result as text.

Description

FIXED(number, decimals)

FIXED(4567.786,1) returns 4567.8

  • Calci displays an #ERROR message, if number is non-numeric.
  • 'decimals' is optional. If not mentioned, Calci assumes it as '2'.

Examples

Function Output
4567.786 4567.8
4567.786 4567.8
4567.786 4567.8
4567.786 4567.8
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/FIXED&oldid=195373"