When you enter formulas on Excel you will sometimes get an Excel error "The formula you typed contains an error". So how to lớn fix this error on Excel?

While entering a calculation formula on Excel you will sometimes encounter some errors that lead to lớn the inability lớn complete the formula, for example with an Excel error "The formula you typed contains an error". Although we have revised the function to lớn the correct formula, we still report the above sầu error. So how khổng lồ fix this error on Excel when importing formulas?

10 ways to recover corrupted Excel files7 most common Excel errors for office peopleFix "File Error: data may have been lost" error in Excel

Instructions for fixing formula errors in Excel

Excel formula error "The formula you typed contains an error" will have the content as shown below. The example below is the RANK formula that ranks but reports an error.

Bạn đang xem: “the formula you typed contains an error


Then Excel will ask you lớn fix the error by:

For more information about the recipe, cliông chồng Help.For help entering a function, click Function Winzard (Formulas tab, Funtion Library group).If you do not try to enter a formula, avoid using an equal sign (=) or minus sign (-), or before it with an apostrophe (").

When you click OK, Excel will indicate the wrong place khổng lồ correct it. But the problem here is that you edited it but still reported the error. So where is this formula error on Excel? There will be 2 ways to lớn edit.


Method 1: Change the sign in the formula

In the entry, the formula = RANK (C2, $ C $ 2: $ C $ 7.0).

This is a completely standard formula, but it still fails because of unsigned conversion. and mark, should allow this error lớn occur. The temporary plan is khổng lồ change the seal, seal; in the formula.

The formula when changing the sign will be = RANK (C2; $ C $ 2: $ C $ 7; 0) . The data area has been selected correctly. Finally press Enter lớn finish.


Results will appear shortly thereafter.


Method 2: How khổng lồ change a semicolon in Excel

After temporarily fixing the above error, we will proceed lớn fix the error on the computer. You need to lớn make trailing settings. to mark, to lớn apply to lớn the formula.

Xem thêm: Bitrate Trong Video Là Gì ? Bitrate Trong Video, Âm Thanh Bao Nhiêu Là Đẹp?

Step 1:

We open Control Panel on the computer and find the Clock, Language, & Region section to choose Change date time or number format .


With Win XP, go to the Start button & select Control Panel, cliông chồng on the Regional và language Options và select Customize.


With Windows 7 , go lớn Control Panel & select Cloông xã, Language, and Region, click Change the date, time, or number format.


Step 2:

Click on Additional Settings . as shown below.


Step 3:

Switch to the Customize Format interface, adjust the following:

Decimal symbol: By mặc định, the sign is now changed khổng lồ a sign. okDigit grouping symbol: Default is the sign. và you move sầu to the sign, okay.

After editing cliông chồng the Apply button and clichồng OK to save sầu the changes.


So you have a way lớn fix the formula The formula you typed contains an error on Excel. Please kiểm tra the sign, in the formula & replace it with a; for the recipe. In case you do not want lớn change the sign in the system and edit in Control Panel, use the method of 1 to fix the mark.

See more:

How lớn fix Errors were detected while saving files in Excel 2010How to lớn fix Vietnamese typing errors in Word, Excel3 basic methods to lớn avoid data entry errors in Excel

I wish you all success!

Nổ hũ club online uy tín | link tải 567live app|W88 | ứng dụng qqlive download| tải mmlive apk | b52 club - Game đánh bài online hot nhất VN