Common Errors Occur In Excel Operations
Error manifestations, Causes, and workarounds in Excel
#####
Error width
The character in the cell is longer than the width of the column =>Use the mouse to drag thecolumn wide tomatch
When you enter the date or time value as a negative number.
#VALUE!
Error value
You enter a string formula while the function requires a number or a logical value.
Entering one or editing elements of a formula that press Enter.
Enter too many parameters for an operator or a function while they only use one parameter.Example = LEFT (A2: A5)
Executes a marco (automated command )relatedto afunctionthat returns the #VALUE! Error.
Appears when in formulas there are calculations that are not of the same data type.For example, the formula = A1 + A2,where A1 is a number, A2 is a letter, because 1 is an arithmetic character, and Tây Ninh is a character string so it cannot perform calculations.To fix, you must edit for the values of the operations that have the same data type as arithmetic characters or string literals.

# DIV / 0!
Error divided by 0
Enter the divisor formula as 0. For example = A1 / B1 where B1 = 0.
The divisor in the formula is a reference to a blank cell.
#NAME!
Wrong name
You use non-permanent functions in Excel such as EDATE, EOMONTH, NETWORKDAYS, WORKDAYS, . Then you need to go tothe Tools - Add-in menu.Tick the Analysis ToolPak utility.
Enter the wrong name for a function.This case happens when you use Vietnamese keyboard in Telex mode to accidentally make the function name as IF become ER, VLOOKUP to VLÔKUP.
Use illegal characters in formulas.
Enter a string in the formula without closingand opening quotation marks. ""
No colon: inthe range of cell addresses in the formula.
(Excel does not recognize the nameof the formula. For example, the function = SM (BBB), in this function, both the formula name and the array name are incorrect. To fix it, you must correct the function nameor enter it correct array to reference.)
# N / A
Data error
Incompatible return values from [color =] [/ color] lookup functions like VLOOKUP, HLOOKUP, LOOKUP or MATCH.
Use HLOOKUP, VLOOKUP, MATCH to return a value in an unsorted table.
Inconsistent data when you use array addresses in Excel.
Forget one or more arguments in the generated function.
Using an improperly created function
(Occurs when the formula refers to a cell in an array, but the cell has no value. This error often occurs with search functions such as VLOOKUP, HLOOKUP, etc. Fix the cell that the function refers to.)
#REF!
Wrong reference region
Delete the cells that are referenced by the formula.Or paste the values generated from the formula into the formulareference regionitself.
(This is a cell reference error, for example, if you delete a row or column that is used in a formula, the #REF! Error will be displayed.)
Link or reference to an application that cannot be run.
#NUM!
Number data error
Using an inappropriate argument in a formula that uses argument as anumeric dataFor example, youenter a negative number formula while it only calculates positive numbers.
Repeated use of the function results in a function that returns no results.
Use a function that returns a number that is too big or too small for Excel's calculation capabilities .
(The numeric value in the formula is invalid, the number is too large or too small. For example, the calculation = 99 ^ 999 will get the #NUM! Error, you just need to reduce the recalculated value.)
#NULL!
Empty data error
Using an inappropriate sequence of operators
Use an array without separators.
(This error occurs when using operators like = SUM (A1: A5 B1: B5), there is no intersection between these two functions , to fix you must determine the exact intersection point between the two functions. .)
5 ★ | 1 Vote
You should read it
- 7 most common Excel errors for office people
- List of common shortcuts for Google Sheets on Android (Last part)
- 10 ways to use the Paste feature in Excel
- Get started with Excel for beginners
- Tips for adding in Excel you need to know
- Common error messages in Excel cells
- Forgot password protected Excel file, what should you do?
- List of common shortcuts for Google Sheets on Mac (Part 2)
May be interested
- 16 Essential Tips In Excelin the course of learning computer office, you should also accumulate yourself a number of tricks necessary to help the process work faster, which you may not have been trained through school or courses.
- Basic MS word errors encountered in office computing.learn the errors in basic office informatics, learn how to correct basic errors in ms word of office computing.
- Common Shortcuts When Using Websitecommon shortcuts when using the website, these shortcuts work on most popular browsers today such as internet explorer, firefox, chrome, ...
- Instructions on how to convert measurement units in Microsoft Word 2007there are many people who have difficulty knowing how to convert units in microsoft word 2007. this article will help you learn how to convert measurement units in word with just a few steps. very simple!
- How to automatically shut down Windows 7, 8 and XP computer automatically?how to schedule a simple shutdown quickly. you often forget to turn off your computer, or you want to do it even faster to turn off your computer.
- Office 2007 installation guideyou want to install microsoft office 2007 on your computer. the following tutorial will help you somewhat about installing the microsoft office 2007 word processor