The NBHU() function is designed to automatically obtain the value of the official exchange rate of the Hungarian forint directly from the website of the Central Bank of Hungary (mnb.hu) by the specified code and date.
The NBHU function significantly simplifies work with currency exchange rates, especially for those who work with finance or maintain accounting 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 currency exchange rates" tool, which inserts the exchange rate for selected cells in one click.
=NBHU(CurrCode; [CurrDate])The NBHU() function is easy to use. You just need to enter the currency code and date into the corresponding cells of the formula, and Excel (Calc) will automatically retrieve the current exchange rate:
=NBHU(CurrCode; CurrDate)
We will have the following result:
The following values are used in this example:
The NBHU() 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 appropriate parameters. Then 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 to 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 function NBHU() by installing the extension YLC Utilities.
After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).
