The NBUK() function is designed to automatically retrieve the value of the official British pound exchange rate directly from the Bank of England website (bankofengland.co.uk) by the specified code and date.
The NBUK function greatly simplifies working with exchange rates, especially for those who deal with finances 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 currency rate for selected cells in one click.
=NBUK(CurrCode; [CurrDate])The NBUK() 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 retrieve the current exchange rate:
=NBUK(CurrCode; CurrDate)
We will get the following result:
In this example, the following values are used:
The NBUK() function can work both in normal mode and as an array function.
To use it 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 array cell and press Ctrl+/.
If you need to convert an array formula to values - select the entire array and in the menu
When using a date as text, it must first be converted into a real date, for example:
You can use the function NBUK() by installing the extension YLC Utilities.
After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).
