The NBDK() function is designed to automatically obtain the official exchange rate of the Danish krone directly from the Central Bank of Denmark website (nationalbanken.dk) by the specified code and date.
The NBDK function significantly simplifies working with currency rates, especially for those who work with finance or maintain accounting in different currencies. Instead of manual rate entry, it is enough for you to use this function to obtain current data.
Also, you can use the "Official currency exchange rates" tool, which inserts the currency rate for selected cells in one click.
=NBDK(CurrCode; CurrDate)The NBDK() function is easy to use. You just need to enter the currency code and date in the corresponding cells of the formula, and Excel (Calc) will automatically get the current currency rate:
=NBDK(CurrCode; CurrDate)
We will have the following result:
In this example, the following values are used:
The NBDK() function can work both in normal mode and as an array function.
To use it as an array, simply enter the function in any cell, specifying the corresponding parameters. After that, you need to press Ctrl+Shift+Enter to enter the array formula and LO Calc will automatically return a table with data.
To select all cells related to the array formula, simply select any cell of the array and press Ctrl+/.
If it is necessary to convert the array formula into values - select the entire array and in the
When using a date in the form of text, it must first be converted into a real date, for example:
You can use the NBDK() function by installing the YLC Utilities extension.
After this, this function will be available in all files that are opened in Excel (LibreOffice Calc).
