Difference between revisions of "Documentation/How Tos/Calc: DOLLAR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
Line 31: | Line 31: | ||
* [[Documentation/How_Tos/Calc:_TEXT_function|<div style="font-size: 120%;">Text]] | * [[Documentation/How_Tos/Calc:_TEXT_function|<div style="font-size: 120%;">Text]] | ||
* [[Documentation/How_Tos/Calc:_TRIM_function|<div style="font-size: 120%;">Trim]] | * [[Documentation/How_Tos/Calc:_TRIM_function|<div style="font-size: 120%;">Trim]] | ||
+ | * [[Documentation/How_Tos/Calc:_UNICODE_function|<div style="font-size: 120%;">Unicode]] | ||
+ | * [[Documentation/How_Tos/Calc:_UNICHAR_function|<div style="font-size: 120%;">Unichar]] | ||
* [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]] | * [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]] | ||
* [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]] | * [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]] |
Revision as of 11:25, 29 January 2024
CALC FUNCTIONS
< {{#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
}}