Windy.ExchangeRates.HNB

Antonio Nakić-Alfirević · Functions
A package containing a single Excel function for converting any currency to Croatian kuna.

Free

Instructions
Contains a single Excel function – Windy.ToHRK. It’s used for converting any currency to Croatian kuna based on the buying, middle or selling rate defined from the Croatian National Bank on the specified date.
Example

The following formula converts an amount of Euros specified in cell A1 to Croatian kunas based on the buying rate defined from the Croatian National Bank.

=Windy.ToHRK(A1,"EUR",DATE(2021,4,1),1)

Parameters
  • amount/iznos - the amount of money to convert
  • fromCurrency - the currency to convert from (e.g. "EUR", "USD", "GBP")
  • date - the date for which the exchange rate is taken
  • type/tip - specifies the type of exchange rate to use
    • 0 - middle rate
    • 1 - buying rate
    • 2 - selling rate