How to fix Excel error 'The formula you typed contains an error'
While entering a calculation formula on Excel you will sometimes encounter some errors that lead to the inability to complete the formula, for example with an Excel error 'The formula you typed contains an error'. Although we have revised the function to the correct formula, we still report the above error. So how to fix this error on Excel when importing formulas?
- 10 ways to recover corrupted Excel files
- 7 most common Excel errors for office people
- Fix "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.
Then Excel will ask you to fix the error by:
- For more information about the recipe, click 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 to 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 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 to occur. The temporary plan is to 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 finish.
Results will appear shortly thereafter.
Method 2: How to change a semicolon in Excel
After temporarily fixing the above error, we will proceed to fix the error on the computer. You need to make trailing settings. to mark, to apply to the formula.
Step 1:
We open Control Panel on the computer and find the Clock, Language, and Region section to choose Change date time or number format .
With Win XP, go to the Start button and select Control Panel, click on the Regional and language Options and select Customize.
With Windows 7 , go to Control Panel and select Clock, 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 default, the sign is now changed to a sign. ok
- Digit grouping symbol: Default is the sign. and you move to the sign, okay.
After editing click the Apply button and click OK to save the changes.
So you have a way to fix the formula The formula you typed contains an error on Excel. Please check the sign, in the formula and replace it with a; for the recipe. In case you do not want to change the sign in the system and edit in Control Panel, use the method of 1 to fix the mark.
See more:
- How to fix Errors were detected while saving files in Excel 2010
- How to fix Vietnamese typing errors in Word, Excel
- 3 basic methods to avoid data entry errors in Excel
I wish you all success!
You should read it
- How to use formula suggestions in Excel on the web
- How to enter formula data in Excel
- How to correct a #REF! Error in Excel
- How to fix the date #VALUE error in Excel
- How to color formula cells in Excel automatically
- Excel errors do not jump formulas and fixes
- How to lock formulas in Excel
- MS Excel 2007 - Lesson 6: Calculation in Excel
May be interested
- How to hide and show the formula bar in Excel easilythe formula bar in excel is an important tool that helps users work quickly. however, you can hide or show the formula bar when necessary. let's find out how to do it in the following article.
- How to color formula cells in Excel automaticallycoloring formula cells in excel helps us quickly identify cells that use formulas in long data tables.
- MS Excel 2007 - Lesson 6: Calculation in Excelexcel supports many calculation functions, logic functions for calculating, filtering, collating and analyzing data. this is also a feature that makes excel an indispensable tool for office jobs. in this article, tipsmake.com will show you how to use the overview calculation function in excel 2007.
- How to lock formulas in Excelwhen sharing an excel file, you don't want other people to edit the formulas, see the formulas, then lock the formulas again.
- Guidelines for importing Chemistry formulas in Excelentering chemistry formulas in excel spreadsheets helps us to handle formulas more easily, especially for those who often have to work with chemistry or with math when they have the above index, the index below.
- What is ### error in Excel? how to fix ### error in Excel### in excel is an error that excel frequently encounters and appears in many different cases when we enter data in excel, functions in excel, enter formulas in excel or when displaying results.
- The square root formula in Excel - The square root function in Excelthe square root formula in excel - the square root function in excel. excel is a spreadsheet to help you with tasks such as calculations or statistics. excel has many types of functions that make it easier to calculate, including the square root function sq
- Fix Windows cannot find, make sure you typed the name correctlyprovide 2 ways to fix the error windows cannot find, make sure you typed the name correctly on the computer with just a few simple and easy steps. click to see now!
- How to delete quick recipe on Excelin addition to locking excel formulas, we can delete formulas and retain results, or delete all cells with formulas and results.
- IFERROR function in Excel, formulas, and usagethe iferror function in excel corrects a formula error, returning a different value that replaces the error message in the normal way.