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

CURRENCYDIFF

Calculates the difference between two specified currencies of the same type.

Syntax

=CURRENCYDIFF(currency, currency)

Arguments

ArgumentTypeDescription
currencyCurrencyAmount

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