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