Microsoft Office Excel is one of the most used software to get work done, especially those related to numbers and calculations, because this software has many formulas to help you complete complex calculations in one tap.
Sounds easy, right? In fact, you need foresight and thoroughness in the process. When all data has been entered neatly, the formula has also been entered correctly, but the result that comes out is #ERROR! What’s wrong, huh?
Don’t worry, you are not alone in this. All users (even Pros!) must have experienced errors in using Excel such as accidentally deleting data, misplaced numbers, and so on. For that, I put together some ways to overcome the nightmare of using Microsoft Office Excel. Come on, see!
TIP! Before we get started, here are some very helpful and interesting tips to take a look at, which I’ve learned to minimize your mistakes and make using Excel easier:
- Start all formulas with the equals symbol (=)
- Use the symbol (*) for multiplication instead of “X”
- Make sure the cells are correct and in pairs
- Use quotation marks on words in each formula
7 Errors You Most Often Meet in Microsoft Office Excel
This error appears when Excel finds a space, character, or text in a formula that should be a number. Excel can only process formulas from cells that contain numbers, so it won’t respond when you input anything else.
The fix: Double-check your formula, making sure it only uses numbers. If the error persists, try to check if there are any blank cells. formulas that fail can be caused by cells or the use of special characters that you use.
Do not be surprised when this error appears, because it turns out that the problem is in the column that is not wide enough! Hehe, so the solution is to simply slide or widen your column so that the formula results can appear in full in the column.
Pro Tip: Double-click on the border on the right so that the column automatically adjusts to the size of the resulting formula.
Excel will display this error when a formula points to a cell that contains zero or blank numbers. The fix is relatively easy, just make sure the divisor in the formula is not zero or an empty cell.
This error is quite tricky because it references an invalid sell. What this means is that you may have accidentally deleted or pasted a cell used in a formula. To be clear, let’s look at the following example:
Then if we accidentally delete the column “Number 2”, we will get this error:
Before you paste a set of cells, make sure none of the formulas are affected. Similarly, when you want to delete a cell, it is important to double-check whether there is a formula that is being used for that cell.
Pro Tip: If you accidentally delete a cell, you can undo it by clicking CTRL+Z.
This error occurs when you specify two areas of cells that do not intersect, or when you use the wrong range operator. To provide additional context, here’s how Excel’s operator reference works:
- The colon (:) range operator is a reference to multiple cells at once.
- The comma (,) union operator combines two cell references into one reference.
- Intersection operator space to return a reference at the intersection (intersection) of two cell ranges.
In the example above, it can be seen that cells A2 and C2 are on a line that does not intersect, an error occurs because the operator reference used is the Intersection operator that uses spaces, it should use a colon operator reference.
First things first, check again to make sure you have used the correct syntax in your formula. Use a colon (colon) to separate the first cell from the last cell when using a continuous range in a formula.
When Excel shows this error, it means that the number referred to in your formula could not be found. It is possible that the row or number used in the formula has been deleted or was not previously stored. For advanced users, this error usually appears when cells using the VLOOKUP formula cannot be found.
Overcome this error by re-checking all the formulas used. Be sure to carefully comb through which sections have been omitted or misreferenced. If you have multiple linked formulas, check again to make sure all formulas have values.
If your formula contains invalid numeric values, then this error will appear in Excel. This often happens when you enter a different number value from another in your formula.
For example, when entering Excel formulas, make sure not to use the currency format for the numbers used. Instead of entering $1,000, it’s better to just type 1000, then format the cells with currency type and commas after the formula is used.
To resolve this error, double check whether you are still using the currency, date, or other special symbol formats. Then also make sure to remove those characters from the formula, leaving only numbers. Here’s how to format the numbers after removing the comma and currency from your formula:
To customize the currency, click the small triangle on the icon on the right and select the appropriate currency.
Microsoft Excel will certainly be very helpful when you input data for business. Therefore, it is very important to use genuine Microsoft Office Excel. If you want to explore some of Excel’s powerful features and want to know if there is a spreadsheet software that is simpler and easier to use than Excel?