writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − + − + − + − + Line 14:
Line 15: − + − + − + − +
no edit summary
=DOLLAR(num, dec)=
=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 ==
== Description ==
DOLLAR(num, dec)
DOLLAR (Amount,Decimals)
For Example,
For Example,
DOLLAR(4657.894,2) returns ''$4,657.89''
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.
*If any of the argument is invalid, Calci displays an #NaN error message.