Difference between revisions of "Manuals/calci/FIXED"

From ZCubes Wiki
Jump to navigation Jump to search
 
(9 intermediate revisions by 3 users not shown)
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 ==
 
== Description ==
  
FIXED(number, decimals)
+
FIXED (Number,DecPlaces)
 
+
*For Example, FIXED(4567.786,1) ''returns 4567.8''
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.
 
*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 as '2'.
+
*The result is displayed as a text.
  
 
== Examples ==
 
== Examples ==
Line 26: Line 24:
  
 
|- class="odd"
 
|- 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="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="odd"
| class="sshl_f" | 4567.786
+
| class="sshl_f" | FIXED(-45)
| class="sshl_f" | 4567.8
+
| class="sshl_f" | -45.00
  
 
|- class="even"
 
|- class="even"
| class="sshl_f" | 4567.786
+
| class="sshl_f" | FIXED(7866.44,-2)
| class="sshl_f" | 4567.8
+
| class="sshl_f" | 7900
 
|}
 
|}
 +
 +
==Related Videos==
 +
{{#ev:youtube|Zcgujc-joxM|280|center|FIXED}}
 +
 +
== See Also ==
 +
 +
*[[Manuals/calci/ROUND | ROUND]]
 +
*[[Manuals/calci/ROUNDUP | ROUNDUP]]
 +
*[[Manuals/calci/ROUNDDOWN| ROUNDDOWN]]
 +
*[[Manuals/calci/TRUNC | TRUNC]]
 +
 +
==References==
 +
 +
*[http://en.wikipedia.org/wiki/Rounding#Types_of_rounding Types of Round functions]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 17: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.

Description

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.

Examples

Function Output
FIXED(35.56,1) 35.6
FIXED(99999.9,4) 99999.9000
FIXED(-45) -45.00
FIXED(7866.44,-2) 7900

Related Videos

FIXED

See Also

References