Other Functions — functions

Functions

330. GIA_Other_Average

(Range, Condition)

Returns the average of values in the range of cells, meeting a chosen criteria (absolute/negative/positive).

331. GIA_Other_Count

(Range, Condition)

Returns the number of values in the range of cells, meeting a chosen criteria (negative/positive/zero).

332. GIA_Other_DoubleInterpolationFromArrays

(Array1, Array2, Values, Point1, Point2)

Interpolates the value for a specific location in the first array and in the second array.

333. GIA_Other_DoubleInterpolationFromGrid

(Grid, Point1, Point2)

Interpolates the value for a specific location in the leftmost column and in the topmost row in the grid.

334. GIA_Other_ConvertValueToUSD

(Value, CCY, Spot)

Converts the value in terms of currency other than USD to value in terms of USD.

335. GIA_Other_CCYUSDorUSDCCY

(CCY)

Returns either CCYUSD or USDCCY string, depending on the input currency. If the input currency is one of the following – EUR, GBP, AUD or NZD, the output is CCYUSD, otherwise it is USDCCY.

336. GIA_Other_CCY1CCY2

(CCY1, CCY2, Hierarchy)

Returns either CCY1CCY2 or CCY2CCY1 string, depending on which of the currencies is base and which one is the counter currency. If CCY1 is base and CCY2 is counter, the output is CCY1CCY2, otherwise it is CCY2CCY1.

337. GIA_Other_Sum

(Range, Condition)

Returns the sum of values in the range of cells, meeting a chosen criteria (Absolute/Negative/Positive).