SOLVED

Need help with broken formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1865829%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20broken%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865829%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20this%20problem%20with%20a%20new%20computer%2C%20where%20I%20simply%20cannot%20perform%20a%20formula%20that%20is%20referencing%20something%20else%20-%20it%20always%20appears%20the%20warning%20of%20broken%20formula.%20Example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20When%20I%20start%20to%20write%20%3DVlookup(B2%3B%20the%20warning%20appears%20immediately...%20I%20have%20the%20same%20problem%20with%20pretty%20much%20every%20other%20formula%2C%20SUMIF%2C%20etc...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20fix%20this%3F%3C%2FP%3E%3CP%3EThanks%20a%20lot!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1865829%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1865919%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20broken%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865919%22%20slang%3D%22en-US%22%3EPlease%20share%20the%20Workbook%20with%20us%20and%20let%20us%20examine%20the%20issue!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1866515%22%20slang%3D%22de-DE%22%3ESubject%3A%20Need%20help%20with%20broken%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1866515%22%20slang%3D%22de-DE%22%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAs%20Mr.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3ERajesh%20Sinha%20%3C%2FA%3Ehas%20already%20recommended%2C%20send%20a%20file%20(without%20sensitive%20data)%20so%20that%20you%20can%20be%20helped%20faster%20and%20more%20precisely.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt%20would%20be%20an%20avantage%20if%20you%20added%20the%20Excel%20version%20and%20the%20operating%20system%20to%20the%20information.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENevertheless%2C%20here%20is%20some%20information%20in%20advance.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20avoid%20broken%20formulas%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-avoid-broken-formulas-8309381d-33e8-42f6-b889-84ef6df1d586%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-avoid-broken-formulas-8309381d-33e8-42f6-b889-84ef6df1d586%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F862123%22%20target%3D%22_blank%22%3E%40DiogoMota%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1866551%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20broken%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1866551%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F862123%22%20target%3D%22_blank%22%3E%40DiogoMota%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGuessing%3A%3C%2FP%3E%3CP%3EYou%20seems%20to%20have%20a%20%22mixed%20language%22%20system%20since%20you%20use%20a%20English%20formula%20but%20Semicolon%20(%3B)%20as%20separator.%20Try%20using%20a%20comma%20(%2C)%20instead%20of%20Semicolon%20(%3B).%3C%2FP%3E%3CP%3E%3CSPAN%3EVlookup(B2%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20you%20want%20to%20use%20%3B%20as%20separator%20you%20probably%20have%20to%20change%20language%2Fregional%20settings.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fformula-errors%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fformula-errors%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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!

4 Replies
Highlighted
Please share the Workbook with us and let us examine the issue!
Highlighted

 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

https://support.microsoft.com/en-us/office/how-to-avoid-broken-formulas-8309381d-33e8-42f6-b889-84ef...

 

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

@DiogoMota

Highlighted
Best Response confirmed by DiogoMota (New Contributor)
Solution

@DiogoMota 

Guessing:

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

 

Highlighted

@MindreVetande, Thanks a lot! It was exactly that!