Difference between revisions of "Manuals/calci/FIXED"

Latest revision as of 16:25, 9 August 2018

FIXED (Number,DecPlaces)

where 'Number' is the number to round, and
'DecPlaces' is the number of digits after the decimal point.
- FIXED(), formats a number as text with a fixed number of decimals.

FIXED (Number,DecPlaces)

For Example, FIXED(4567.786,1) returns 4567.8
'Number' can be up to 15 bit number. If exceeded, Calci displays #ERROR message.
If 'Number' is negative, Calci rounds the number to left of the decimal point.
Calci displays an #ERROR message, if number is non-numeric.
'DecPlaces' is optional. If not mentioned, Calci assumes it to be '2'.
The result is displayed as a text.

@@ Line 1: / Line 1: @@
-=FIXED(number, decimals)=
+<div style="font-size:30px">'''FIXED (Number,DecPlaces) '''</div><br/>
-*where 'number' is the number to round, and
+*where 'Number' is the number to round, and
+*'DecPlaces' is the number of digits after the decimal point.
-*'decimals' is the number of digits after the decimal point.
+**FIXED(), formats a number as text with a fixed number of decimals.
-FIXED() rounds a number to the specified number of decimals, and displays the result as text.
 == Description ==
-FIXED(number, decimals)
+FIXED (Number,DecPlaces)
+*For Example, FIXED(4567.786,1) ''returns 4567.8''
-For Example,
+*'Number' can be up to 15 bit number. If exceeded, Calci displays #ERROR message.
+* If 'Number' is negative, Calci rounds the number to left of the decimal point.
-FIXED(4567.786,1) ''returns 4567.8''
-*'number' can be up to 15 bit number. If exceeded, Calci displays #ERROR message.
-* If 'number' is negative, Calci rounds the number to left of the decimal point.
 *Calci displays an #ERROR message, if number is non-numeric.
+*'DecPlaces' is optional. If not mentioned, Calci assumes it to be '2'.
-*'decimals' is optional. If not mentioned, Calci assumes it to be '2'.
 *The result is displayed as a text.