Difference between revisions of "Manuals/calci/DOLLAR"

Latest revision as of 16:09, 22 August 2018

DOLLAR (Amount,Decimals)

where, $Amount$ is a number
is number of digits to right of the decimal point
- DOLLAR(), converts a number to text, using the $ (dollar) currency format.

Description

DOLLAR (Amount,Decimals)

For Example,

DOLLAR(4657.894,2) returns $4,657.89

can be a number or reference to a cell containing a number.
specifies the number of digits to the right of the decimal point to be displayed in the output.
If is negative, the output is rounded to left of the decimal point.
If is omitted, Calci assumes it to be 2.
If any of the argument is invalid, Calci displays an #NaN error message.

Examples

Function	Output
DOLLAR(345.4556,3)	$345.456
DOLLAR(33.52,1)	$33.5
DOLLAR(0.625)	$0.63
DOLLAR(1768.28,-1)	$1,770.0
DOLLAR(1334,3)	$1,334.00

References

Dollar

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''DOLLAR'''</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)</font></font></font>
+<div style="font-size:30px">'''DOLLAR (Amount,Decimals)'''</div><br/>
-<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 a number, and dec is the number of digits to the right of the decimal point. </font></font></font>
+*where, <math>Amount</math> is a number
+*<math>Decimals</math> is number of digits to right of the decimal point
+**DOLLAR(), converts a number to text, using the $ (dollar) currency format.
-</div>
+== Description ==
-----
-<div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">It converts a number to text using currency format, with the decimals rounded to the specified place. </font></font></font></div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-DOLLAR
+DOLLAR (Amount,Decimals)
-</div></div>
+For Example,
-----
-<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,Column1Row2)</font></font></font>
+DOLLAR(4657.894,2) returns ''$4,657.89''
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=DOLLAR(C1R1,C1R2)</font></font></font>
+*<math>Amount</math> can be a number or reference to a cell containing a number.
+*<math>Decimals</math> specifies the number of digits to the right of the decimal point to be displayed in the output.
+*If <math>Decimals</math> is negative, the output is rounded to left of the decimal point.
+*If <math>Decimals</math> is omitted, Calci assumes it to be 2.
+*If any of the argument is invalid, Calci displays an #NaN error message.
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=DOLLAR(4567.894,2) is $4,567.89</nowiki></font></font></font>
+== Examples ==
-</div>
+<div id="6SpaceContent" class="zcontent" align="left">
-----
-<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>
-----
-<div id="4SpaceContent" class="zcontent" align="left">
-{| id="TABLE1" class="SpreadSheet blue"
+{| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="   " |
+| class="  " | '''Function'''
-<div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+| class="  " | '''Output'''
-| Column1
-| class="  " | Column2
-| class="  " | Column3
-| class="  " | Column4
 |- class="odd"
-| class=" " | Row1
+| class="sshl_f" |DOLLAR(345.4556,3)
-| class="sshl_f" | 4567.894
+| class="sshl_f" |$345.456
-| class="sshl_f" | 2
-| class="sshl_f" |
-| class="sshl_f" |
 |- class="even"
-| class="  " | Row2
+| class="sshl_f" |DOLLAR(33.52,1)
-| class="sshl_f" | $4,567.89
+| class="sshl_f" |$33.5
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
 |- class="odd"
-| Row3
+| class="sshl_f" |DOLLAR(0.625)
-| class="sshl_fSelectTD SelectTD " |
+| class="sshl_f" |$0.63
-<div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
 |- class="even"
-| Row4
+| class="sshl_f" |DOLLAR(1768.28,-1)
-| class="sshl_f" |
+| class="sshl_f" |$1,770.0
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
 |- class="odd"
-| class=" " | Row5
+| class="sshl_f" |DOLLAR(1334,3)
-| class="sshl_f" |
+| class="sshl_f" |$1,334.00
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="even"
-| Row6
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+==Related Videos==
-----
+{{#ev:youtube|Dn6BrR7chJs|280|center|DOLLAR}}
+== See Also ==
+*[[Manuals/calci/EUROCONVERT | EUROCONVERT]]
+==References==
+*[http://en.wikipedia.org/wiki/Dollar Dollar]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]