How to fix “Excel The formula you typed contains an error” error when typing

While using Excel, you get the error “The formula you typed contains an error” but do not know how to fix it. Follow up and work with Taimienphi.vn to fix the error with just a few steps.

Fix Excel error The formula you typed contains an error

Causes of Excel Errors The formula you typed contains an error

The error message “The formula you typed contains an error” appears with the message that the formula you entered has an error. Along with some information
– For more information on formula correction, select Help.
– For help in entering the function, select Function Wizard (Formula tab, Function library group).
– If you are not entering a formula, avoid using the equal sign (=), minus sign (-), or preceded by an apostrophe (‘).

Instructions for fixing Excel errors The formula you typed contains an error

Method 1: Temporarily replace the sign in the formula
– For formulas in Excel, comma (,) is the sign in the standard formula. But when we enter the formula, it still fails, the reason is that we have not set the dot (.) and comma (,) conversion. So the temporary solution is you replace comma (,) with semicolon (;) in the formula is okay.
– When you enter the formula and press Entera notice board will appear, press Yes to continue.

Links to download versions

– Excel 2021
– Excel 2019
– Excel 2016
– Excel 2013

Method 2: Convert dots to commas on the computer
Step 1: Press the key combination Windows + CHEAPimport Control Panelpress Enter to access the window Control Panel.

Step 2: Section Clock and Region, choose Change date, time, or number formats.

Step 3: Click Additional Settings.

Step 4: Friend reset two items as follows:
– Decimal symbol: current default is comma (,) you change to dot (.)
– Digit grouping symbol: current default is dot (.) you convert to comma (,)

Step 5: Press Applythen select OK.

https://thuthuat.taimienphi.vn/cach-sua-loi-excel-the-formula-you-typed-contains-an-error-70682n.aspx
So you have succeeded in converting dots to commas on your computer. When entering formulas in Excel, remember to check the mark again. With the above operations, you can completely fix the Excel error “The formula you typed contains an error” when using Excel. The error of the slow excel file is also quite common for those who often use Excel spreadsheets, causing a lot of trouble and discomfort, you see how to fix slow excel file error on Taimienphi.