Manuals/calci/DOLLAR - Revision history

Devika at 22:09, 22 August 2018

2018-08-22T22:09:05Z

Devika at 21:47, 23 July 2018

2018-07-23T21:47:33Z

Devika at 21:46, 23 July 2018

2018-07-23T21:46:21Z

Jayaram at 10:48, 14 March 2017

2017-03-14T10:48:12Z

Swapna at 18:09, 28 April 2015

2015-04-28T18:09:38Z

Swapna at 16:17, 5 January 2014

2014-01-05T16:17:19Z

Swapna at 21:36, 31 December 2013

2013-12-31T21:36:58Z

Swapna at 21:34, 31 December 2013

2013-12-31T21:34:15Z

MassBot1: Created page with "
'''DOLLAR'''
2013-10-25T02:34:04Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''DOLLAR'''</font></font></font><font color="#4848..."

New page
<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>

<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>

</div>
----
<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

</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,Column1Row2)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=DOLLAR(C1R1,C1R2)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=DOLLAR(4567.894,2) is $4,567.89</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>
----
<div id="4SpaceContent" class="zcontent" align="left">

{| id="TABLE1" class="SpreadSheet blue"
|- class="even"
| class=" " |
<div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| Column1
| class=" " | Column2
| class=" " | Column3
| class=" " | Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 4567.894
| class="sshl_f" | 2
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class=" " | Row2
| class="sshl_f" | $4,567.89
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| Row3
| class="sshl_fSelectTD SelectTD " |
<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" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class=" " | Row5
| class="sshl_f" |
| 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>
----

@@ Line 3: / Line 3: @@
 *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.
 == Description ==

← Older revision		Revision as of 21:47, 23 July 2018
Line 1:		Line 1:
−	~~=DOLLAR(num, dec)=~~
	<div style="font-size:30px">'''DOLLAR (Amount,Decimals)'''</div><br/>		<div style="font-size:30px">'''DOLLAR (Amount,Decimals)'''</div><br/>

@@ Line 1: / Line 1: @@
 =DOLLAR(num, dec)=
-*where, <math>num</math> is a number
+*where, <math>Amount</math> is a number
-*<math>dec</math> is number of digits to right of the decimal point
+*<math>Decimals</math> is number of digits to right of the decimal point
-DOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol.
+DOLLAR(), converts a number to text, using the $ (dollar) currency format.
 == Description ==
-DOLLAR(num, dec)
+DOLLAR (Amount,Decimals)
 For Example,
@@ Line 14: / Line 15: @@
 DOLLAR(4657.894,2) returns ''$4,657.89''
-*<math>num</math> can be a number or reference to a cell containing a number.
+*<math>Amount</math> can be a number or reference to a cell containing a number.
-*<math>dec</math> specifies the number of digits to the right of the decimal point to be displayed in the output.
+*<math>Decimals</math> specifies the number of digits to the right of the decimal point to be displayed in the output.
-*If <math>dec</math> is negative, the output is rounded to left of the decimal point.
+*If <math>Decimals</math> is negative, the output is rounded to left of the decimal point.
-*If <math>dec</math> is omitted, Calci assumes it to be 2.
+*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.

← Older revision		Revision as of 10:48, 14 March 2017
Line 61:		Line 61:

	*[http://en.wikipedia.org/wiki/Dollar Dollar]		*[http://en.wikipedia.org/wiki/Dollar Dollar]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 49: / Line 49: @@
 | class="sshl_f" |$1,334.00
 |}
 == See Also ==

@@ Line 52: / Line 52: @@
 == See Also ==
-*[[Manuals/calci/BAHTTEXT | BAHTTEXT]]
+*[[Manuals/calci/EUROCONVERT | EUROCONVERT]]
 ==References==
 *[http://en.wikipedia.org/wiki/Dollar Dollar]

@@ 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>
+=DOLLAR(num, dec)=
-<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>num</math> is a number
-</div>
+DOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol.
-DOLLAR
+== Description ==
-</div></div>
+DOLLAR(num, dec)
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let’s see an example in (Column1 Row 1,Column1Row2)</font></font></font>
+For Example,
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=DOLLAR(C1R1,C1R2)</font></font></font>
+DOLLAR(4657.894,2) returns ''$4,657.89''
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=DOLLAR(4567.894,2) is $4,567.89</nowiki></font></font></font>
+*<math>num</math> can be a number or reference to a cell containing a number.
-</div>
+== Examples ==
-{| id="TABLE1" class="SpreadSheet blue"
+<div id="6SpaceContent" class="zcontent" align="left">
 |- class="even"
-| class="   " |
+| class="  " | '''Function'''
-<div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+| class="  " | '''Output'''
-| Column1
 |- 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="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="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="even"
-| Row4
+| class="sshl_f" |DOLLAR(1768.28,-1)
-| class="sshl_f" |
+| class="sshl_f" |$1,770.0
 | class="sshl_f" |
 |- class="odd"
-| class=" " | Row5
+| class="sshl_f" |DOLLAR(1334,3)
-| class="sshl_f" |
+| class="sshl_f" |$1,334.00
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+== See Also ==
-----