Difference between revisions of "Documentation/How Tos/Calc: DOLLAR function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
 
(8 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.
  
{{Documentation/SeeAlso|
+
=== Issues: ===
 +
* 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: FIXED function|FIXED]]
  
Line 24: Line 32:
 
* [[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]]
=== Issues: ===
+
* Because it depends on local settings, <tt>'''DOLLAR'''</tt> should not be regarded as portable.
+

Latest revision as of 15:28, 2 February 2024



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.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_DOLLAR_function&oldid=260101"
Views
Personal tools
Navigation
Tools