0
You may see an error box telling you you have not entered the correct arguements. You also could receive a variety of error displays. Some are: #DIV/0!, #NAME?, #VALUE!, #SYNTAX?
Wiki User
∙ 14y ago
Wiki User
∙ 12y agoDepends entirely on what the error is. The program might not work at all, or might just give a wrong answer.
Wiki User
∙ 12y agoThere is no simple answer to that as it will depend on what the error is. There are all sorts of potential errors that you could make when creating a formula.
Add your answer:
Earn +20 pts
How to Fix Microsoft Office Error Code 30029 1007?
How do you deactivate circular reference in Microsoft Excel?
A formula cannot directly or indirectly refer to the cell the formula is in. If it does, you get a circular reference. You need to check through your formulas and find out what is causing it. Then you need to fix your formulas. If you don't, your spreadsheet will not work.
How do you fix xbox 360 error code 8c010003 without an xbox.com account?
Microsoft has to fix it it's internal
How do you fix circular data in Excel?
A circular reference error is caused when a formula directly or indirectly refers to the cell that the formula has been typed in. When this happens you will see the cell that the circular reference is in at the bottom of the worksheet. You need to check the formula in that cell and formulas in other cells that it refers to in order to find the problem. Then you can change the formula so that you can still do what you want without the error.
What can you do if receiving a Compile error in hidden module error message?
A compile error in hidden module error message refers to the start up file of Microsoft Word and Excel. The error could be due to malicious malware unintentionally downloaded by the user. The fix depends on which operating system the person is using. Find and rename the files ComctlLib.exd and MSComctlLib.exd, adding .old to the end of the filename. The error message should then be gone.
How do you fix the Microsoft c plus plus error?
Too many errors possible to say. Please elaborate.
What do you remove if Excel does not accept the formula?
There is no simple answer to that. There are many reasons why a formula would not be accepted. It will depend on what the problem is and you may even have to add something to the formula to fix it, not remove something.
What does error code 800704DC on xbox?
According to Microsoft, the error code 8000704DC on the Xbox means there is an error downloading your Xbox Live profile. You will need to visit your account, change your password, and clear stored information on your console to fix the error.
Why does my running total suddenly stop working in Microsoft Excel?
I set up function to give me a running total (or so I thought) that seems to work perfectly for the first few cells, but then suddenly stops working. It gives totally incorrect numbers that don't seem to come from anywhere. How can I fix this, clever people? This is my first time using Excel and I'm a little lost. As I say, the formula works perfectly for the first part. The calculation is, and has always been, set to automatic and I can't see an error in the function.
How do you fix error code 80072efe windows update?
If you download Microsoft Security Essentials and make it scan your computer, it will find viruses that cause the error, and will allow you to remove them. If Microsoft Security Essentials can't run (because it needs to update), look for the update online.
How do you fix autoIt error?
autoIt error how can i fix this problem
How do you fix Microsoft Visual Basic 2010 Express Error Corrupt resources file Unable to read resources from this file because of invalid header information?
You can fix the Microsoft Visual Basic 2010 Express Error, Corrupt resources file, Unable to read resources from this file because of invalid header information, by downloading a new set up that is not corrupt.
