Asked in
Software and Applications (non-game)
Snow and Ice
Statistics
Microsoft Excel

What are the different types of errors in Microsoft Excel and their causes?

Answer

User Avatar
Wiki User
November 08, 2008 1:20PM

There are several as best I can recall. Here they are with basic reason you might encounter them. Using the built in Excel help you will get more detail and assistance in solving them

#VALUE! - You are trying to perform a calculation or function with an improper type, e.g. taking the absolute value of a string

#DIV/0! - You are dividing by zero

#NAME? - The function you are using is unknown

#REF! - The cell you are refering to is no longer a valid cell address

#NUM! - The numeric result in that cell is too big

#N/A - Several different situations can cause this

#NULL - A null or 'no data' is in that cell