The NBPL() function is designed to automatically obtain the value of the official Polish zloty exchange rate directly from the Central Bank of Poland website (nbp.pl) by the specified code and date.
The NBPL function significantly facilitates work with currency rates, especially for those who work with finances or keep records in different currencies. Instead of manual entry of rates, you just need to use this function to get up-to-date data.
Also, you can use the tool "Official exchange rates", which inserts the exchange rate for selected cells in one click.
=NBPL(CurrCode; CurrDate)The NBPL() 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 receive the current exchange rate:
=NBPL(CurrCode; CurrDate)
We will have the following result:
In this example, the following values are used:
The NBPL() function can work both in normal mode and as an array function.
To use as an array, simply enter the function into 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 an 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 menu
When using a date in text format, it must first be converted into a real date, for example:
You can use the function NBPL() by installing the extension YLC Utilities.
After this, this function will be available in all files that are opened in Excel (LibreOffice Calc).
