The NBEU() function is designed for automatically obtaining the official euro exchange rate directly from the website of the European Union Central Bank (ecb.eu) by the specified code and date.
The NBEU function greatly simplifies working with exchange 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 import actual data directly into the Excel (LibreOffice Calc) cell.
Also, you can use the tool "Official exchange rates", which inserts the exchange rate for selected cells in one click.
=NBEU(CurrCode; [CurrDate]; [Modifier])
The NBEU() function is simple to use. You just need to enter the currency code and date into the corresponding formula cells, and Excel (Calc) will automatically get the actual currency rate:
=NBEU(CurrCode; CurrDate)
We will get the following result:
In this example, the following values are used:
The NBEU() 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 array cell and press Ctrl+/.
If it is necessary to convert an array formula into a value - 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 NBEU() function by installing the YLC Utilities extension.
After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).
