Common errors that can occur while making formulas
The below mentioned tutorial will brief you about the common errors that people make while making formulas in the excel application.
1) Open and Close parentheses do not match
You should always ensure that, the open and the close parentheses always match. The excel application will show the parentheses in colors when you make a formula. In a formula, there should be an equal number of matching open and close parentheses.
2) Colon symbol may not be used to indicate a range of cells
When you indicate a range of cells in a formula, ensure that you have indicated the range using a colon symbol. For example, if you are using the cell range A1 to A5, indicate this range in the formula as A1:A5.
3) Required arguments may not be entered properly
Ensure that all the required arguments for a formula are entered correctly and also ensure that you do not enter too many arguments inside a function.
4) More than 64 functions may be nested
Though, this is a rare occurrence, ensure that you have nested not more than 64 functions inside a formula.
5) Other Worksheets names may be enclosed in the formula incorrectly
When you enclose cells or values that are contained in another Worksheet or workbook and, if that worksheet’s name starts with a non alphabetical character, then ensure that you have enclosed that worksheet’s name within a single Quotation (‘) mark.
6) A path to External Workbooks may be entered incorrectly
You should always ensure that, the External reference to a workbook includes the name of the workbook and the right path.
7) Numbers that include formatting may be entered
You should ensure that the numbers that you enter should be free of any kind of formatting. For example, if you want to enter the number as $200, ensure you enter the number only as 200 and not $200.
Avoid division by Zero.
So, these are the Common Errors that might occur when making formulas in Excel application.
See also How to make a formula using Nested functions in Excel 2010 application
Read Other Applications