EUROCONVERT (PQL - xl)

This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros)

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

EUROCONVERT(number, source, target, OPTIONAL full precision, OPTIONAL triangulation precision)

Function Arguments

Name

Description

Type

Optional

number

Number to convert

Number

source

ISO currency code for the number to convert

String

target

ISO currency code for the result of the conversion

String

full precision

Logical value representing whether to display the value in full precision or not; if omitted, the value is not displayed in full precision

StringOrNumber

Y

triangulation precision

Integer greater than or equal to 3 that specifies the number of significant digits to be used for the intermediate Euro value when converting between two Euro member currencies

Number

Y

Comments

This function is the same as the Microsoft Excel 'EUROCONVERT' function - using the same inputs, logic and outputs.