These docs are for v1.0. Click to read the latest docs for v1.2.

CURRENCY

Creates a currency from the specified amount and type, defaulting to USD if the type isn't specified.

Syntax

=CURRENCY(value, type)

Arguments

ArgumentTypeDescription
valueNumberAmount of currency
typeString(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