CURRENCY
Creates a currency from the specified amount and type, defaulting to USD if the type isn't specified.
Syntax
=CURRENCY(value, type)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | Amount of currency |
| type | String | (Optional) The type of currency, defaults to USD. List of options found here |
Examples
=CURRENCY(9.99)→$9.99
=CURRENCY(1, "EUR")→€1.00
=CURRENCY(55, "AUD")→A$55.00
Updated over 1 year ago