WD.EXCHANGE
Description
Converts a value to a value with a currency unit, according to the exchange rate you
specify. The function multiplies the numeric value of value by the numeric value of
exchange_rate_value, setting the units to the unit value of exchange_rate_value if
specified, or to the unit value of exchange_rate_unit if present.
Syntax
WD.EXCHANGE(value,exchange_rate_value,[exchange_rate_unit])
- value: The value to convert. The value can be a simple number or a number with a currency unit. The function ignores the currency unit portion of the argument if you included it.
- exchange_rate_value: The exchange rate value. The value can be a simple number or a number with a currency unit. If you specify a simple number, you must also specify the argument exchange_rate_unit. If you specify a number with a currency unit, the function uses the specified unit unless you specified the optional exchange_rate_unit argument.
- exchange_rate_unit: The exchange rate currency unit as a string or as the units from a value with a currency unit. The function ignores the value portion of the argument if you included it.