Search Results for

    Show / Hide Table of Contents

    IP.EXCHANGERATE function

    Description

    Returns the exchange rate.

    Syntax

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

    BaseCurrency (required) Base currency code (3 char)
    ComparisonCurrency (required) Comparison currency code (3 char)
    DateTime (required) Date and time effective from (yyyy-mm-dd hh:mm)
    RateType (optional) Exchange rate type code

    Example:

    =IP.EXCHANGERATE("GBP","EUR","2024-01-25 12:00","DEFAULT")

    Important

    The DateTime parameter must be enclosed in double quotes.

    e.g. "2024-01-25 12:00"


    Note

    Exchange rate types

    There are Author based exchange rate types but the User can add their own.

    In this article
    Back to top Generated by DocFX