consolidation-financial-planningYou can use a LUCANET formula to query exchange rates in Lucanet and read them in to MS Excel.
To read in exchange rates from Lucanet to MS Excel, the LUCANET formula must be set up as follows:
The formula name specifies the exchange rate to be read into MS Excel. The following formula names can be entered:
| Formula name | Description |
|---|
| RATE.CLOSING | Returns the closing exchange rate for a month |
| RATE.AVERAGE | Returns the average exchange rate for a month |
| RATE.YTD | Returns the YTD rate of a month |
| 1/LN.RATE.CLOSING | Returns the reciprocal value of the closing exchange rate for a month |
| 1/LN.RATE.AVERAGE | Returns the reciprocal value of the average exchange rate for a month |
| 1/LN.RATE.YTD | Returns the reciprocal value of the YTD exchange rate for a month |
This content was generated using AI and reviewed by Lucanet subject matter experts before publication.