CURRENCYDIFF
Calculates the difference between two specified currencies of the same type.
Syntax
=CURRENCYDIFF(currency, currency)
Arguments
| Argument | Type | Description |
|---|---|---|
| currency | Currency | Amount |
Examples
=CURRENCYDIFF(CURRENCY(0.2), CURRENCY(0.3))→$0.10
=CURRENCYDIFF(CURRENCY(0.1, "EUR"), CURRENCY(0.2, "EUR"))→€0.10
=CURRENCYDIFF(CURRENCY(0.1, "AUD"), CURRENCY(0.2, "AUD"))→A$0.10
=CURRENCYDIFF(CURRENCY(0.1, "AUD"), CURRENCY(0.2, "EUR"))→#ERROR!
Attempts to get the difference between two currencies, but it's invalid because they are of different types
Updated 10 months ago