<<<Index>>>

Errors returned from formulas


  • ######

    • Column not wide enough to display the result (not an error)

    • Negative date or time

  • #DIV/0!

    • Dividing a number by zero or by an empty cell

  • #N/A

    • Function missing required parameters

  • #NAME?

    • Invalid cell range reference

    • Named range does not exist

    • Function does not exist

    • Another worksheet that does not exist

  • #NUM!

    • Bad argument to a function

  • #REF!

    • Cells do not contain any data

  • #VALUE!

    • Wrong datatype, e.g.
      =SUM("oops")

<<<Index>>>