Difference between revisions of "Documentation/How Tos/Calc: DOLLAR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
(9 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:DOLLAR function}} |
+ | {{Documentation/CalcFunc TextTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_DECIMAL_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_EXACT_function | ||
+ | }}__NOTOC__ | ||
== DOLLAR == | == DOLLAR == | ||
Line 17: | Line 22: | ||
: returns <tt>'''$367.46'''</tt>, if your currency is US dollars. | : returns <tt>'''$367.46'''</tt>, if your currency is US dollars. | ||
− | {{ | + | === Issues: === |
− | * [[Documentation/How_Tos/Calc: FIXED function|FIXED]] | + | * Because it depends on local settings, <tt>'''DOLLAR'''</tt> should not be regarded as portable. |
+ | |||
+ | {{SeeAlso|EN| | ||
+ | * [[Documentation/How_Tos/Calc: FIXED function|FIXED]] | ||
− | * [[Documentation/How_Tos/Calc: Text functions|Text functions]] | + | * [[Documentation/How_Tos/Calc: Text functions|Text functions]] |
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | + | [[Category: Documentation/Reference/Calc/Text functions]] | |
− | |||
− |
Latest revision as of 15:28, 2 February 2024
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
DOLLAR
Returns text representing a number in your local currency format.
Syntax:
DOLLAR(number; decimals)
- returns text representing number as currency. decimals (optional, assumed to be 2 if omitted) sets the number of decimal places.
- Tools - Options - Language Settings - Languages - 'Default Currency' sets the currency to be used (normally be the currency of your locale).
Example:
DOLLAR(255)
- returns $255.00, if your currency is US dollars.
DOLLAR(367.456; 2)
- returns $367.46, if your currency is US dollars.
Issues:
- Because it depends on local settings, DOLLAR should not be regarded as portable.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}