"the formula you typed contains an error" office 2011 mac

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 khổng lồ complete the formula, for example with an Excel error "The formula you typed contains an error". Although we have sầu revised the function khổng lồ the correct formula, we still report the above error. So how khổng lồ fix this error on Excel when importing formulas?

10 ways lớn recover corrupted Excel files7 most comtháng Excel errors for office peopleFix "File Error: data may have sầu 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 nội dung 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" office 2011 mac


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, cliông chồng Function Winzard (Formulas tab, Funtion Library group).If you bởi vì not try khổng lồ enter a formula, avoid using an equal sign (=) or minus sign (-), or before it with an apostrophe (").

When you cliông xã OK, Excel will indicate the wrong place to lớn 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. & mark, should allow this error khổng lồ occur. The temporary plan is lớn 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 to lớn finish.


Results will appear shortly thereafter.


Method 2: How to change a semicolon in Excel

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

Xem thêm: Sinh Ngày 14/4 Là Cung Gì ? Xem Cung Hoàng Đạo Sinh Ngày 14 Tháng 4

Step 1:

We open Control Panel on the computer và find the Clochồng, Language, và Region section to choose Change date time or number format .


With Win XP., go to lớn the Start button và select Control Panel, click on the Regional và language Options and select Customize.


With Windows 7 , go to Control Panel và select Clochồng, Language, and Region, cliông chồng Change the date, time, or number format.


Step 2:

Click on Additional Settings . as shown below.


Step 3:

Switch khổng lồ the Customize Format interface, adjust the following:

Decimal symbol: By default, the sign is now changed to lớn a sign. okDigit grouping symbol: Default is the sign. and you move to lớn the sign, okay.

After editing clichồng the Apply button và cliông xã OK lớn save the changes.

Xem thêm: Giải Đáp Thắc Mắc: Sau Sinh Bao Lâu Thì Tử Cung Co Lại ? Co Hồi Tử Cung Là Gì


So you have sầu a way khổng lồ fix the formula The formula you typed contains an error on Excel. Please kiểm tra the sign, in the formula và replace it with a; for the recipe. In case you vị not want lớn change the sign in the system & edit in Control Panel, use the method of 1 lớn fix the mark.

See more:

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

I wish you all success!

Chuyên mục: Blockchain