Difference between revisions of "CURRENCY()"
From Lianjapedia
Barrymavin (Talk | contribs) (→Description) |
Yvonne.milne (Talk | contribs) |
||
(4 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to prefix numeric value with currency character | Function to prefix numeric value with currency character | ||
− | |||
==Syntax== | ==Syntax== | ||
− | CURRENCY(< | + | CURRENCY(<expN1> [, <expN2>]) |
− | + | ||
==See Also== | ==See Also== | ||
[[SET CURRENCY]] | [[SET CURRENCY]] | ||
− | |||
==Description== | ==Description== | ||
− | The CURRENCY() function returns the specified < | + | The CURRENCY() function returns the specified <expN1> as a character string prefixed with the current currency character which can be set with the command SET CURRENCY TO <expC>. The default for SET CURRENCY is "$". The optional <expN2> can be used to increase the number of decimal places. By default, two decimal places are returned, but this can be increased up to four. The <expN1> is rounded to the number of decimal places if required. |
Note for locale specific settings: | Note for locale specific settings: | ||
Line 25: | Line 22: | ||
? currency(88.00) | ? currency(88.00) | ||
$88.00 | $88.00 | ||
+ | ? currency(123.4567) | ||
+ | $123.46 | ||
+ | ? currency(123.4567,4) | ||
+ | $123.4567 | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:Numeric Data Functions]] | [[Category:Numeric Data Functions]] |
Latest revision as of 06:14, 4 March 2013
Contents
Purpose
Function to prefix numeric value with currency character
Syntax
CURRENCY(<expN1> [, <expN2>])
See Also
Description
The CURRENCY() function returns the specified <expN1> as a character string prefixed with the current currency character which can be set with the command SET CURRENCY TO <expC>. The default for SET CURRENCY is "$". The optional <expN2> can be used to increase the number of decimal places. By default, two decimal places are returned, but this can be increased up to four. The <expN1> is rounded to the number of decimal places if required.
Note for locale specific settings:
To change the separator character from a ',' use the SET SEPARATOR TO command.
To change the point character from a '.' use the SET POINT TO command.
Example
set currency to "$" ? currency(88.00) $88.00 ? currency(123.4567) $123.46 ? currency(123.4567,4) $123.4567