The NBCZ() function is designed to automatically obtain the official exchange rate of the Czech koruna directly from the Central Bank of the Czech Republic website (cnb.cz) by the specified code and date.
The NBCZ function significantly simplifies working with exchange rates, especially for those who work with finance or keep records in different currencies. Instead of manually entering rates, you just need to use this function to get up-to-date data.
Also, you can use the "Official exchange rates" tool, which inserts the exchange rate for selected cells in one click.
=NBCZ(CurrCode; [CurrDate])The NBCZ() function is easy to use. You just need to enter the currency code and date into the corresponding formula cells, and Excel (Calc) will automatically get the current exchange rate:
=NBCZ(CurrCode; CurrDate)
We will have the following result:
In this example, the following values are used:
The NBCZ() function can work both in normal mode and as an array function.
To use as an array, simply enter the function in any cell, specifying the appropriate 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 associated with the array formula, simply select any cell of the array and press Ctrl+/.
If you need to convert an array formula into values - select the entire array and in the
When using a date as text, it must first be converted into a real date, for example:
You can use the NBCZ() function by installing the YLC Utilities extension.
After that, this function will be available in all files opened in Excel (LibreOffice Calc).
