Erori excel si cauza erorilor

Error

Description

####

The column is not wide enough to accommodate the data. Widen the column to see the entire cell contents by clicking on the column border and dragging it to increase the size of the column width. You can also double-click the column border to automatically size the column to exactly fit the data. The error disappears.

#DIV/0!

The formula is trying to divide a number by 0 or an empty cell.

#NAME?

The formula contains incorrectly spelled cell or function names.

#VALUE!

The formula contains non-numeric data, or cell or function names that cannot be used in the formula.

#REF!

The formula contains a reference to a cell that is invalid. Often, this means you deleted a referenced cell.

Circular reference

Results when one of the cells you are referencing in the formula is the cell in which you want the formula to appear. All the other items in this table show up as codes in the cells, while the circular reference error shows up as an error message.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: