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

 72 total views


In the process of using Excel, sometimes we encounter errors but do not know where we are wrong. For example, with the Excel error “The formula you typed contains an error”, you have edited the function, entered the correct formula many times, but still the above error is displayed. So how to fix this Excel error “The formula you typed contains an error”.

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.

The formula you typed contains an error 2

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

The formula you typed contains an error 3

Step 3: Click Additional Settings.

formula you typed contains an error 4

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 (,)

The formula you typed contains an error 5

Step 5: Press Applythen select OK.

The formula you typed contains an error 6

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.

Related keywords:

How to fix Excel error The formula you typed contains an error

fix error The formula you typed contains an error in Excel, formula error in Excel,

Close Bitnami banner

Related Posts

Leave a Reply

Your email address will not be published.

%d bloggers like this:
Ads Blocker Image Powered by Code Help Pro

Support our free content

It\'s a beautiful day for an ad, please support rvgamepc by disabling your ads blocker <3

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock
Close Bitnami banner
Bitnami