Manuals/calci/FIXED - Revision history

Devika at 22:25, 9 August 2018

2018-08-09T22:25:00Z

2018-08-09T22:24:34Z

2017-03-14T11:42:17Z

2015-04-17T20:44:01Z

2013-11-21T12:58:26Z

2013-11-19T22:10:45Z

2013-11-19T21:59:22Z

References

2013-11-19T21:50:04Z

2013-11-19T21:48:53Z

2013-11-19T21:44:09Z

← Older revision		Revision as of 22:25, 9 August 2018
Line 1:		Line 1:
−	~~=FIXED(number, decimals)=~~
	<div style="font-size:30px">'''FIXED (Number,DecPlaces) '''</div><br/>		<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

@@ Line 1: / Line 1: @@
 =FIXED(number, decimals)=
-*where 'number' is the number to round, and
+<div style="font-size:30px">'''FIXED (Number,DecPlaces) '''</div><br/>
+*where 'Number' is the number to round, and
-*'decimals' is the number of digits after the decimal point.
+*'DecPlaces' is the number of digits after the decimal point.
+**FIXED(), formats a number as text with a fixed number of decimals.
 == 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.
 *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.

← Older revision		Revision as of 11:42, 14 March 2017
Line 63:		Line 63:

	*[http://en.wikipedia.org/wiki/Rounding#Types_of_rounding Types of Round functions]		*[http://en.wikipedia.org/wiki/Rounding#Types_of_rounding Types of Round functions]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 49: / Line 49: @@
 | class="sshl_f" | 7900
 |}
 == See Also ==

← Older revision		Revision as of 22:10, 19 November 2013
Line 57:		Line 57:
	==References==		==References==

−	*[http://en.wikipedia.org/wiki/Nearest_integer_function FIXED Function]
	*[http://en.wikipedia.org/wiki/Rounding#Types_of_rounding Types of Round functions]		*[http://en.wikipedia.org/wiki/Rounding#Types_of_rounding Types of Round functions]

← Older revision		Revision as of 21:59, 19 November 2013
Line 57:		Line 57:
	==References==		==References==

−	*[http://en.wikipedia.org/wiki/~~Trigonometric_functions List~~ of ~~Trigonometric Functions~~]	+	*[http://en.wikipedia.org/wiki/Nearest_integer_function FIXED Function]
		+	*[http://en.wikipedia.org/wiki/Rounding#Types_of_rounding Types of Round functions]

@@ Line 51: / Line 51: @@
 *[[Manuals/calci/ROUND | ROUND]]
-*[[Manuals/calci/ROUND UP | ROUND UP]]
+*[[Manuals/calci/ROUNDUP | ROUNDUP]]
-*[[Manuals/calci/ROUND DOWN| ROUND DOWN]]
+*[[Manuals/calci/ROUNDDOWN| ROUNDDOWN]]
 *[[Manuals/calci/TRUNC | TRUNC]]

@@ Line 12: / Line 12: @@
 FIXED(4567.786,1) ''returns 4567.8''
-*'number' can be up to 15 bit number. If exceeded, Calci displays #ERROR! message.
+*'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.
@@ Line 47: / Line 47: @@
 | class="sshl_f" | 7900
 |}

@@ Line 11: / Line 11: @@
 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'.
+*'decimals' is optional. If not mentioned, Calci assumes it to be '2'.
 == Examples ==
@@ Line 26: / Line 32: @@
 |- class="odd"
-| class="sshl_f" | 4567.786
+| class="sshl_f" | FIXED(35.56,1)
-| class="sshl_f" | 4567.8
+| class="sshl_f" | 35.6
 |- class="even"
-| class="sshl_f" | 4567.786
+| class="sshl_f" | FIXED(99999.9,4)
-| class="sshl_f" | 4567.8
+| class="sshl_f" | 99999.9000
 |- class="odd"
-| class="sshl_f" | 4567.786
+| class="sshl_f" | FIXED(-45)
-| class="sshl_f" | 4567.8
+| class="sshl_f" | -45.00
 |- class="even"
-| class="sshl_f" | 4567.786
+| class="sshl_f" | FIXED(7866.44,-2)
-| class="sshl_f" | 4567.8
+| class="sshl_f" | 7900
 |}