Nov 08 2020 09:30 PM
Hi everyone,
I have this problem with a new computer, where I simply cannot perform a formula that is referencing something else - it always appears the warning of broken formula. Example:
1) When I start to write =Vlookup(B2; the warning appears immediately... I have the same problem with pretty much every other formula, SUMIF, etc...
Does anyone know how to fix this?
Thanks a lot!
Nov 08 2020 10:48 PM
Nov 09 2020 02:20 AM
As Mr.Rajesh Sinha has already recommended, send a file (without sensitive data) so that you can be helped faster and more precisely.
It would be an avantage if you added the Excel version and the operating system to the information.
Nevertheless, here is some information in advance.
How to avoid broken formulas
Thank you for your understanding and patience
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Nov 09 2020 02:27 AM
SolutionGuessing:
You seems to have a "mixed language" system since you use a English formula but Semicolon (;) as separator. Try using a comma (,) instead of Semicolon (;).
Vlookup(B2,
If you want to use ; as separator you probably have to change language/regional settings.
https://docs.microsoft.com/en-us/office/troubleshoot/excel/formula-errors
Nov 10 2020 02:50 AM
@MindreVetande, Thanks a lot! It was exactly that!
Nov 09 2020 02:27 AM
SolutionGuessing:
You seems to have a "mixed language" system since you use a English formula but Semicolon (;) as separator. Try using a comma (,) instead of Semicolon (;).
Vlookup(B2,
If you want to use ; as separator you probably have to change language/regional settings.
https://docs.microsoft.com/en-us/office/troubleshoot/excel/formula-errors