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.

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>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.
-DOLLAR(), converts a number to text, using the $ (dollar) currency format.
 == Description ==