writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''FIXED'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''num'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,dec,nc)</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where num '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the number which is to round and convert to text and</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''dec'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the number of digits to the right of the decimal point and</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''nc'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is a logical value </font></font></font>+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">FIXED rounds a number to the specified number of decimals,and calculates the result as text.</font></font></font></div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − FIXED+ − </div></div>+ − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − <font color="#484848"><font face="Arial, sans-serif"><font size="2">let’s see an example in (Column1 Row 1,Column2Row1)</font></font></font>+ − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=FIXED(C1R1,C2R1)</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=FIXED(4567.786,1) is 4567.8</nowiki></font></font></font> − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − + − | Column1+ − + − | Column3 − | Column4 − | class=" " | Row1 − | class="sshl_f" | 1 − | class=" sshl_f " |+ − | class=" " | Row2+ − + − <div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>+ − − | class=" SelectTD SelectTD" | − <div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | − | Row3+ − + − + − − | − | Row4+ − |+ − | − | − | class=" " | − |- class="odd" − − | − | − − | − |- class="even" − | Row6 − | − | − | − − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
no edit summary
=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=" " | Column2
|- 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=" sshl_f " |
| class="sshl_f" | 4567.8
|
|
|- class="even"
|- class="even"
| class="sshl_f" | 4567.786
| class="sshl_f" | 4567.8
| class=" " | Row5
|
|
|}
|}