Revision as of 15:46, 23 July 2018

DOLLAR(num, dec)

DOLLAR (Amount,Decimals)

DOLLAR(), converts a number to text, using the $ (dollar) currency format.

DOLLAR (Amount,Decimals)

For Example,

DOLLAR(4657.894,2) returns $4,657.89

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

@@ Line 1: / Line 1: @@
 =DOLLAR(num, dec)=
+<div style="font-size:30px">'''DOLLAR (Amount,Decimals)'''</div><br/>
-*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.