IP.EXCHANGERATE function

Description

Returns the exchange rate.

Syntax

=IP.EXCHANGERATE(BaseCurrency, ComparisonCurrency, DateTime, RateType)

BaseCurrency	(required)	Base currency
ComparisonCurrency	(required)	Comparison currency
DateTime	(required)	Date and time effective from
RateType

Example:

=IP.EXCHANGERATE("Pound Sterling","Euro",20/12/2023)