The error you’re encountering in Excel is due to the fact that the formula is being treated as text rather than a formula. This typically happens because of regional settings, particularly the use of the semicolon (;) as an argument separator in the formula. In some regional settings, Excel expects a comma (,) instead of a semicolon.
To fix this issue, try changing the semicolons to commas in your formula. So, your formula should look like this:
=STOCKHISTORY("EUR:GBP", A2, A2, 0, 0, 1) * B2
If this does not solve the problem, ensure that:
- Your formula is not preceded by an apostrophe, which would turn it into text.
- There are no leading spaces before the
= sign.
Make these changes and see if it resolves the issue.