Difference between revisions of "Manuals/calci/FIXED"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''FIXED'''</font></font></font><font color="#484...") |
|||
| Line 1: | Line 1: | ||
| − | + | =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 == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class="sshl_f" | '''Function''' |
| − | + | | class="sshl_f" | '''Output''' | |
| − | | class=" | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | |||
| class="sshl_f" | 4567.786 | | class="sshl_f" | 4567.786 | ||
| − | |||
| class="sshl_f" | 4567.8 | | class="sshl_f" | 4567.8 | ||
| − | + | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 4567.786 | |
| − | | class="sshl_f | + | | class="sshl_f" | 4567.8 |
| − | + | ||
| − | | class="sshl_f" | | ||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 4567.786 | |
| − | | class=" | + | | class="sshl_f" | 4567.8 |
| − | | | + | |
| − | | | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 4567.786 | |
| − | + | | class="sshl_f" | 4567.8 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class=" " | | ||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
Revision as of 11:00, 19 November 2013
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 |