Error Messages

After entering a formula or opening an Excel file, an error message may appear:

Error Message

Possible Error(s)

#####

Column is not wide enough to display all text. Increase the column width.

#DIV/0!

The formula entered divides by zero.

#FUNCTION!

#FUNC

The Excel function is not supported by EasySpreadsheet. Use the Excel Viewer to view the spreadsheet.

#NAME?

The function entered does not exist in EasySpreadsheet.

#NUM!

Invalid numbers were used in a formula. For example, a function may have required nonnegative numbers, but negative numbers were used.

#VALUE!

The wrong value type may have been used in a formula. For example, a function may have required a logical value, but a numerical value was used.

When using search and replace functions, this message appears when the search text is not found.

#REF!

Invalid cell references were used, or a necessary cell reference was not given.